APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PLIP_F

Line 280: -- START OF BEN_PLIP_F ----------------------

276: ---------------------------------------------------------------
277: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
278: ---------------------------------------------------------------
279: ---------------------------------------------------------------
280: -- START OF BEN_PLIP_F ----------------------
281: ---------------------------------------------------------------
282: cursor c_cpp_from_parent(c_PGM_ID number) is
283: select distinct plip_id
284: from BEN_PLIP_F

Line 284: from BEN_PLIP_F

280: -- START OF BEN_PLIP_F ----------------------
281: ---------------------------------------------------------------
282: cursor c_cpp_from_parent(c_PGM_ID number) is
283: select distinct plip_id
284: from BEN_PLIP_F
285: where PGM_ID = c_PGM_ID ;
286: --
287: cursor c_cpp(c_plip_id number ,c_mirror_src_entity_result_id number,
288: c_table_alias varchar2) is

Line 290: from BEN_PLIP_F cpp

286: --
287: cursor c_cpp(c_plip_id number ,c_mirror_src_entity_result_id number,
288: c_table_alias varchar2) is
289: select cpp.*
290: from BEN_PLIP_F cpp
291: where cpp.plip_id = c_plip_id
292: and not exists (
293: select /* */ null
294: from ben_copy_entity_results cpe

Line 306: -- END OF BEN_PLIP_F ----------------------

302: );
303: l_plip_id number(15);
304: l_out_cpp_result_id number(15);
305: ---------------------------------------------------------------
306: -- END OF BEN_PLIP_F ----------------------
307: ---------------------------------------------------------------
308: ---------------------------------------------------------------
309: -- START OF BEN_PTIP_F ----------------------
310: ---------------------------------------------------------------

Line 773: ben_plip_f plip,

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
777: -- ,pqh_table_route trt

Line 3931: -- START OF BEN_PLIP_F ----------------------

3927: ---------------------------------------------------------------
3928: -- END OF BEN_PTIP_F ----------------------
3929: ---------------------------------------------------------------
3930: ---------------------------------------------------------------
3931: -- START OF BEN_PLIP_F ----------------------
3932: ---------------------------------------------------------------
3933: --
3934: for l_parent_rec in c_cpp_from_parent(l_PGM_ID) loop
3935: --

Line 5099: -- END OF BEN_PLIP_F ----------------------

5095: --
5096: end loop;
5097:
5098: ---------------------------------------------------------------
5099: -- END OF BEN_PLIP_F ----------------------
5100: ---------------------------------------------------------------
5101:
5102: ---------------------------------------------------------------
5103: -- START OF BEN_CMBN_PLIP_F ----------------------

Line 6292: from ben_plip_f cpp

6288: ) return varchar2 is
6289:
6290: cursor c_plip is
6291: select pgm_id,pl_id
6292: from ben_plip_f cpp
6293: where cpp.plip_id = p_plip_id
6294: and p_effective_date between cpp.effective_start_date
6295: and cpp.effective_end_date;
6296: