APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PTIP_F

Line 309: -- START OF BEN_PTIP_F ----------------------

305: ---------------------------------------------------------------
306: -- END OF BEN_PLIP_F ----------------------
307: ---------------------------------------------------------------
308: ---------------------------------------------------------------
309: -- START OF BEN_PTIP_F ----------------------
310: ---------------------------------------------------------------
311: cursor c_ctp_from_parent(c_PGM_ID number) is
312: select distinct ptip_id
313: from BEN_PTIP_F

Line 313: from BEN_PTIP_F

309: -- START OF BEN_PTIP_F ----------------------
310: ---------------------------------------------------------------
311: cursor c_ctp_from_parent(c_PGM_ID number) is
312: select distinct ptip_id
313: from BEN_PTIP_F
314: where PGM_ID = c_PGM_ID ;
315: --
316: cursor c_ctp(c_ptip_id number ,c_mirror_src_entity_result_id number,
317: c_table_alias varchar2) is

Line 319: from BEN_PTIP_F ctp

315: --
316: cursor c_ctp(c_ptip_id number ,c_mirror_src_entity_result_id number,
317: c_table_alias varchar2) is
318: select ctp.*
319: from BEN_PTIP_F ctp
320: where ctp.ptip_id = c_ptip_id
321: and not exists (
322: select /* */ null
323: from ben_copy_entity_results cpe

Line 336: -- END OF BEN_PTIP_F ----------------------

332: );
333: l_ptip_id number(15);
334: l_out_ctp_result_id number(15);
335: ---------------------------------------------------------------
336: -- END OF BEN_PTIP_F ----------------------
337: ---------------------------------------------------------------
338: ---------------------------------------------------------------
339: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
340: ---------------------------------------------------------------

Line 819: ben_ptip_f ptip,

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
823: and ptip.pgm_id = c_pgm_id

Line 856: from BEN_PTIP_F

852: -- START OF BEN_PL_TYP_F ----------------------
853: ---------------------------------------------------------------
854: cursor c_ptp_from_parent(c_PTIP_ID number) is
855: select distinct pl_typ_id
856: from BEN_PTIP_F
857: where PTIP_ID = c_PTIP_ID ;
858: --
859: l_pl_typ_id number(15);
860: l_out_ptp_result_id number(15);

Line 2353: -- START OF BEN_PTIP_F ----------------------

2349: ---------------------------------------------------------------
2350: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
2351: ---------------------------------------------------------------
2352: ---------------------------------------------------------------
2353: -- START OF BEN_PTIP_F ----------------------
2354: ---------------------------------------------------------------
2355: --
2356: for l_parent_rec in c_ctp_from_parent(l_PGM_ID) loop
2357: --

Line 3928: -- END OF BEN_PTIP_F ----------------------

3924: ---------------------------------------------------------------
3925: --
3926: end loop;
3927: ---------------------------------------------------------------
3928: -- END OF BEN_PTIP_F ----------------------
3929: ---------------------------------------------------------------
3930: ---------------------------------------------------------------
3931: -- START OF BEN_PLIP_F ----------------------
3932: ---------------------------------------------------------------

Line 6262: from ben_ptip_f ctp

6258: ) return varchar2 is
6259:
6260: cursor c_ptip is
6261: select pgm_id,pl_typ_id
6262: from ben_ptip_f ctp
6263: where ctp.ptip_id = p_ptip_id
6264: and p_effective_date between ctp.effective_start_date
6265: and ctp.effective_end_date;
6266: