DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_OIPLIP_F

Line 768: -- START OF BEN_OIPLIP_F ----------------------

764: ---------------------------------------------------------------
765: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------
766: ---------------------------------------------------------------
767: ---------------------------------------------------------------
768: -- START OF BEN_OIPLIP_F ----------------------
769: ---------------------------------------------------------------
770: cursor c_opp1_from_parent(c_PGM_ID number, c_table_alias varchar2 ) is
771: select oiplip.oiplip_id,cpe_oipl.copy_entity_result_id
772: from ben_oiplip_f oiplip,

Line 772: from ben_oiplip_f oiplip,

768: -- START OF BEN_OIPLIP_F ----------------------
769: ---------------------------------------------------------------
770: cursor c_opp1_from_parent(c_PGM_ID number, c_table_alias varchar2 ) is
771: select oiplip.oiplip_id,cpe_oipl.copy_entity_result_id
772: from ben_oiplip_f oiplip,
773: ben_plip_f plip,
774: ben_copy_entity_results cpe_oipl,
775: ben_copy_entity_results cpe_pl,
776: ben_copy_entity_results cpe_plip

Line 794: from BEN_OIPLIP_F opp

790: --
791: cursor c_opp1(c_oiplip_id number,c_mirror_src_entity_result_id number ,
792: c_table_alias varchar2) is
793: select opp.*
794: from BEN_OIPLIP_F opp
795: where opp.oiplip_id = c_oiplip_id
796: and not exists (
797: select /* */ null
798: from ben_copy_entity_results cpe

Line 811: -- END OF BEN_OIPLIP_F ----------------------

807: );
808: l_oiplip_id number(15);
809: l_out_opp_result_id number(15);
810: --------------------------------------------------------------
811: -- END OF BEN_OIPLIP_F ----------------------
812: ---------------------------------------------------------------
813: ---------------------------------------------------------------
814: -- START OF BEN_OPTIP_F ----------------------
815: ---------------------------------------------------------------

Line 5528: -- START OF BEN_OIPLIP_F ----------------------

5524: ---------------------------------------------------------------
5525: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------
5526: ---------------------------------------------------------------
5527: ---------------------------------------------------------------
5528: -- START OF BEN_OIPLIP_F ----------------------
5529: ---------------------------------------------------------------
5530: --
5531: for l_parent_rec in c_opp1_from_parent(l_PGM_ID,'COP' ) loop
5532: --

Line 5666: -- END OF BEN_OIPLIP_F ----------------------

5662: ) ;
5663:
5664: end loop;
5665: ---------------------------------------------------------------
5666: -- END OF BEN_OIPLIP_F ----------------------
5667: ---------------------------------------------------------------
5668: /* NOT REQUIRED FOR COPY
5669: -- Only required for Rows Copied count in Log
5670: -- To be uncommented after create_OTP_rows is fixed