APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 220: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------

216: ---------------------------------------------------------------
217: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
218: ---------------------------------------------------------------
219: ---------------------------------------------------------------
220: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
221: ---------------------------------------------------------------
222: cursor c_pgc_from_parent(c_PGM_ID number) is
223: select pgm_dpnt_cvg_ctfn_id
224: from BEN_PGM_DPNT_CVG_CTFN_F

Line 224: from BEN_PGM_DPNT_CVG_CTFN_F

220: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
221: ---------------------------------------------------------------
222: cursor c_pgc_from_parent(c_PGM_ID number) is
223: select pgm_dpnt_cvg_ctfn_id
224: from BEN_PGM_DPNT_CVG_CTFN_F
225: where PGM_ID = c_PGM_ID ;
226: --
227: cursor c_pgc(c_pgm_dpnt_cvg_ctfn_id number ,c_mirror_src_entity_result_id number,
228: c_table_alias varchar2) is

Line 230: from BEN_PGM_DPNT_CVG_CTFN_F pgc

226: --
227: cursor c_pgc(c_pgm_dpnt_cvg_ctfn_id number ,c_mirror_src_entity_result_id number,
228: c_table_alias varchar2) is
229: select pgc.*
230: from BEN_PGM_DPNT_CVG_CTFN_F pgc
231: where pgc.pgm_dpnt_cvg_ctfn_id = c_pgm_dpnt_cvg_ctfn_id
232: and not exists (
233: select /* */ null
234: from ben_copy_entity_results cpe

Line 247: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------

243: );
244: l_pgm_dpnt_cvg_ctfn_id number(15);
245: l_out_pgc_result_id number(15);
246: ---------------------------------------------------------------
247: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
248: ---------------------------------------------------------------
249: ---------------------------------------------------------------
250: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
251: ---------------------------------------------------------------

Line 2228: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------

2224: ---------------------------------------------------------------
2225: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
2226: ---------------------------------------------------------------
2227: ---------------------------------------------------------------
2228: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
2229: ---------------------------------------------------------------
2230: --
2231: for l_parent_rec in c_pgc_from_parent(l_PGM_ID) loop
2232: --

Line 2350: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------

2346: end loop;
2347: --
2348: end loop;
2349: ---------------------------------------------------------------
2350: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
2351: ---------------------------------------------------------------
2352: ---------------------------------------------------------------
2353: -- START OF BEN_PTIP_F ----------------------
2354: ---------------------------------------------------------------