APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 100: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

96: ---------------------------------------------------------------
97: -- END OF BEN_PGM_F ----------------------
98: ---------------------------------------------------------------
99: ---------------------------------------------------------------
100: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
101: ---------------------------------------------------------------
102: cursor c_ldc_from_parent(c_PGM_ID number) is
103: select distinct ler_chg_dpnt_cvg_id
104: from BEN_LER_CHG_DPNT_CVG_F

Line 104: from BEN_LER_CHG_DPNT_CVG_F

100: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
101: ---------------------------------------------------------------
102: cursor c_ldc_from_parent(c_PGM_ID number) is
103: select distinct ler_chg_dpnt_cvg_id
104: from BEN_LER_CHG_DPNT_CVG_F
105: where PGM_ID = c_PGM_ID ;
106: --
107: cursor c_ldc(c_ler_chg_dpnt_cvg_id number ,c_mirror_src_entity_result_id number,
108: c_table_alias varchar2 ) is

Line 110: from BEN_LER_CHG_DPNT_CVG_F ldc

106: --
107: cursor c_ldc(c_ler_chg_dpnt_cvg_id number ,c_mirror_src_entity_result_id number,
108: c_table_alias varchar2 ) is
109: select ldc.*
110: from BEN_LER_CHG_DPNT_CVG_F ldc
111: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
112: --and ldc.business_group_id = p_business_group_id
113: and not exists (
114: select /* */ null

Line 141: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

137: ;
138: l_out_ldc_result_id number(15);
139:
140: ---------------------------------------------------------------
141: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
142: ---------------------------------------------------------------
143: ---------------------------------------------------------------
144: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
145: ---------------------------------------------------------------

Line 369: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

365: ---------------------------------------------------------------
366: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
367: ---------------------------------------------------------------
368: ---------------------------------------------------------------
369: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
370: ---------------------------------------------------------------
371: cursor c_ldc1_from_parent(c_PTIP_ID number) is
372: select distinct ler_chg_dpnt_cvg_id
373: from BEN_LER_CHG_DPNT_CVG_F

Line 373: from BEN_LER_CHG_DPNT_CVG_F

369: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
370: ---------------------------------------------------------------
371: cursor c_ldc1_from_parent(c_PTIP_ID number) is
372: select distinct ler_chg_dpnt_cvg_id
373: from BEN_LER_CHG_DPNT_CVG_F
374: where PTIP_ID = c_PTIP_ID ;
375: --
376: cursor c_ldc1(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number ,
377: c_table_alias varchar2) is

Line 379: from BEN_LER_CHG_DPNT_CVG_F ldc

375: --
376: cursor c_ldc1(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number ,
377: c_table_alias varchar2) is
378: select ldc.*
379: from BEN_LER_CHG_DPNT_CVG_F ldc
380: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
381: and not exists (
382: select /* */ null
383: from ben_copy_entity_results cpe

Line 408: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

404: ;
405: l_out_ldc1_result_id number(15);
406: l_ler_chg_dpnt_cvg_id1 number(15);
407: ---------------------------------------------------------------
408: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
409: ---------------------------------------------------------------
410: ---------------------------------------------------------------
411: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
412: ---------------------------------------------------------------

Line 1475: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

1471: ) ;
1472:
1473:
1474: ---------------------------------------------------------------
1475: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
1476: ---------------------------------------------------------------
1477: --
1478: for l_parent_rec in c_ldc_from_parent(l_PGM_ID) loop
1479: --

Line 1760: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

1756: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
1757: ---------------------------------------------------------------
1758: end loop;
1759: ---------------------------------------------------------------
1760: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
1761: ---------------------------------------------------------------
1762: ---------------------------------------------------------------
1763: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
1764: ---------------------------------------------------------------

Line 3134: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

3130: ---------------------------------------------------------------
3131: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
3132: ---------------------------------------------------------------
3133: ---------------------------------------------------------------
3134: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
3135: ---------------------------------------------------------------
3136: --
3137: for l_parent_rec in c_ldc1_from_parent(l_PTIP_ID) loop
3138: --

Line 3414: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

3410: ---------------------------------------------------------------
3411: --
3412: end loop;
3413: ---------------------------------------------------------------
3414: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
3415: ---------------------------------------------------------------
3416: ---------------------------------------------------------------
3417: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
3418: ---------------------------------------------------------------