810: --------------------------------------------------------------
811: -- END OF BEN_OIPLIP_F ----------------------
812: ---------------------------------------------------------------
813: ---------------------------------------------------------------
814: -- START OF BEN_OPTIP_F ----------------------
815: ---------------------------------------------------------------
816: cursor c_otp1_from_parent(c_PGM_ID number,c_table_alias varchar2 ) is
817: select optip.optip_id,cpe.copy_entity_result_id
818: from ben_optip_f optip,
814: -- START OF BEN_OPTIP_F ----------------------
815: ---------------------------------------------------------------
816: cursor c_otp1_from_parent(c_PGM_ID number,c_table_alias varchar2 ) is
817: select optip.optip_id,cpe.copy_entity_result_id
818: from ben_optip_f optip,
819: ben_ptip_f ptip,
820: ben_copy_entity_results cpe
821: -- ,pqh_table_route trt
822: where ptip.ptip_id = optip.ptip_id
828: --
829: cursor c_otp1(c_optip_id number,c_mirror_src_entity_result_id number ,
830: c_table_alias varchar2) is
831: select otp.*
832: from BEN_OPTIP_F otp
833: where otp.optip_id = c_optip_id
834: and not exists (
835: select /* */ null
836: from ben_copy_entity_results cpe
845: );
846: l_optip_id number(15);
847: l_out_otp_result_id number(15);
848: ---------------------------------------------------------------
849: -- END OF BEN_OPTIP_F ----------------------
850: ---------------------------------------------------------------
851: ---------------------------------------------------------------
852: -- START OF BEN_PL_TYP_F ----------------------
853: ---------------------------------------------------------------
5668: /* NOT REQUIRED FOR COPY
5669: -- Only required for Rows Copied count in Log
5670: -- To be uncommented after create_OTP_rows is fixed
5671: ---------------------------------------------------------------
5672: -- START OF BEN_OPTIP_F ----------------------
5673: ---------------------------------------------------------------
5674: --
5675: for l_parent_rec in c_otp1_from_parent(l_PGM_ID,'OPT') loop
5676: --
5770: --
5771: end loop;
5772: */
5773: ---------------------------------------------------------------
5774: -- END OF BEN_OPTIP_F ----------------------
5775: ---------------------------------------------------------------
5776: end if;
5777: end create_program_result ;
5778: --