SELECT * FROM (
      SELECT  MAX(PEMPH_END_NO_IDX),POLH_SYS_ID,PEMPH_SPOUSE_YN, PEMPH_CHILD_YN
      FROM    PH_GL_POLICY,PH_GL_POL_EMPLOYEE
      WHERE   POLH_SYS_ID = PEMPH_POL_SYS_ID 
      AND     NVL(POLH_MASTER_POLICY_NO,0) BETWEEN :P_FM_MAST_POL_NO AND :P_TO_MAST_POL_NO
      AND     POLH_NO BETWEEN :P_FM_POL_NO AND :P_TO_POL_NO
      AND     POLH_NO NOT IN (SELECT  POLH_NO 
                              FROM    PH_GL_POLICY B
			      WHERE   B.POLH_SYS_ID = POLH_SYS_ID
			      AND     B.POLH_STATUS = 'C'
                              AND     :P_AS_OF_DT >=  B.POLH_END_EFF_FM_DT)
      AND     PEMPH_SYS_ID NOT IN (SELECT  PEMPH_SYS_ID
                                   FROM    PH_GL_POL_EMPLOYEE E
	                           WHERE   E.PEMPH_SYS_ID = PEMPH_SYS_ID
                       	           AND     E.PEMPH_POL_SYS_ID =   POLH_SYS_ID
                         	   AND     :P_AS_OF_DT >= E.PEMPH_EXIT_DT)	
      AND     PEMPH_ID = :Q1_PEMPH_ID1                    	         
      AND     :P_AS_OF_DT BETWEEN POLH_FM_DT AND POLH_TO_DT
      GROUP BY POLH_SYS_ID,PEMPH_SPOUSE_YN, PEMPH_CHILD_YN
	  ORDER BY PEMPH_SPOUSE_YN DESC,PEMPH_CHILD_YN DESC )
	  WHERE ROWNUM =1 ;     

function CF_1Formula return Number is
  retval emp.empno%type;
begin
  SELECT * 
  INTO retval
  FROM 
    (SELECT MAX(empno)
     FROM EMP
     GROUP BY ename
     ORDER BY ename
    ) 
  WHERE ROWNUM = 1;

  RETURN (retval);
end;