DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

185: ---------------------------------------------------------------
186: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------
187: ---------------------------------------------------------------
188: ---------------------------------------------------------------
189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
190: ---------------------------------------------------------------
191: cursor c_peo_from_parent(c_PGM_ID number) is
192: select elig_to_prte_rsn_id
193: from BEN_ELIG_TO_PRTE_RSN_F

Line 193: from BEN_ELIG_TO_PRTE_RSN_F

189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
190: ---------------------------------------------------------------
191: cursor c_peo_from_parent(c_PGM_ID number) is
192: select elig_to_prte_rsn_id
193: from BEN_ELIG_TO_PRTE_RSN_F
194: where PGM_ID = c_PGM_ID ;
195: --
196: cursor c_peo(c_elig_to_prte_rsn_id number ,c_mirror_src_entity_result_id number,
197: c_table_alias varchar2 ) is

Line 199: from BEN_ELIG_TO_PRTE_RSN_F peo

195: --
196: cursor c_peo(c_elig_to_prte_rsn_id number ,c_mirror_src_entity_result_id number,
197: c_table_alias varchar2 ) is
198: select peo.*
199: from BEN_ELIG_TO_PRTE_RSN_F peo
200: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
201: --and peo.business_group_id = p_business_group_id
202: and not exists (
203: select /* */ null

Line 217: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

213: );
214: l_elig_to_prte_rsn_id number(15);
215: l_out_peo_result_id number(15);
216: ---------------------------------------------------------------
217: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
218: ---------------------------------------------------------------
219: ---------------------------------------------------------------
220: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
221: ---------------------------------------------------------------

Line 339: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

335: ---------------------------------------------------------------
336: -- END OF BEN_PTIP_F ----------------------
337: ---------------------------------------------------------------
338: ---------------------------------------------------------------
339: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
340: ---------------------------------------------------------------
341: cursor c_peo1_from_parent(c_PTIP_ID number) is
342: select elig_to_prte_rsn_id
343: from BEN_ELIG_TO_PRTE_RSN_F

Line 343: from BEN_ELIG_TO_PRTE_RSN_F

339: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
340: ---------------------------------------------------------------
341: cursor c_peo1_from_parent(c_PTIP_ID number) is
342: select elig_to_prte_rsn_id
343: from BEN_ELIG_TO_PRTE_RSN_F
344: where PTIP_ID = c_PTIP_ID ;
345: --
346: cursor c_peo1(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,
347: c_table_alias varchar2 ) is

Line 349: from BEN_ELIG_TO_PRTE_RSN_F peo

345: --
346: cursor c_peo1(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number,
347: c_table_alias varchar2 ) is
348: select peo.*
349: from BEN_ELIG_TO_PRTE_RSN_F peo
350: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
351: and not exists (
352: select /* */ null
353: from ben_copy_entity_results cpe

Line 366: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

362: );
363: l_elig_to_prte_rsn_id1 number(15);
364: l_out_peo1_result_id number(15);
365: ---------------------------------------------------------------
366: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
367: ---------------------------------------------------------------
368: ---------------------------------------------------------------
369: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
370: ---------------------------------------------------------------

Line 574: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

570: ---------------------------------------------------------------
571: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
572: ---------------------------------------------------------------
573: ---------------------------------------------------------------
574: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
575: ---------------------------------------------------------------
576: cursor c_peo2_from_parent(c_PLIP_ID number) is
577: select elig_to_prte_rsn_id
578: from BEN_ELIG_TO_PRTE_RSN_F

Line 578: from BEN_ELIG_TO_PRTE_RSN_F

574: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
575: ---------------------------------------------------------------
576: cursor c_peo2_from_parent(c_PLIP_ID number) is
577: select elig_to_prte_rsn_id
578: from BEN_ELIG_TO_PRTE_RSN_F
579: where PLIP_ID = c_PLIP_ID ;
580: --
581: cursor c_peo2(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number ,
582: c_table_alias varchar2) is

Line 584: from BEN_ELIG_TO_PRTE_RSN_F peo

580: --
581: cursor c_peo2(c_elig_to_prte_rsn_id number,c_mirror_src_entity_result_id number ,
582: c_table_alias varchar2) is
583: select peo.*
584: from BEN_ELIG_TO_PRTE_RSN_F peo
585: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
586: and not exists (
587: select /* */ null
588: from ben_copy_entity_results cpe

Line 601: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

597: );
598: l_elig_to_prte_rsn_id2 number(15);
599: l_out_peo2_result_id number(15);
600: ---------------------------------------------------------------
601: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
602: ---------------------------------------------------------------
603: ---------------------------------------------------------------
604: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
605: ---------------------------------------------------------------

Line 1948: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

1944: ---------------------------------------------------------------
1945: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------
1946: ---------------------------------------------------------------
1947: ---------------------------------------------------------------
1948: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
1949: ---------------------------------------------------------------
1950: --
1951: for l_parent_rec in c_peo_from_parent(l_PGM_ID) loop
1952: --

Line 2225: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

2221: --
2222:
2223: end loop;
2224: ---------------------------------------------------------------
2225: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
2226: ---------------------------------------------------------------
2227: ---------------------------------------------------------------
2228: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
2229: ---------------------------------------------------------------

Line 2840: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

2836: ,p_parent_entity_result_id => l_out_ctp_result_id
2837: ) ;
2838:
2839: ---------------------------------------------------------------
2840: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
2841: ---------------------------------------------------------------
2842: --
2843: ---------------------------------------------------------------
2844: -- START OF BEN_PL_TYP_F ----------------------

Line 3131: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

3127: end loop;
3128: --
3129: end loop;
3130: ---------------------------------------------------------------
3131: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
3132: ---------------------------------------------------------------
3133: ---------------------------------------------------------------
3134: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
3135: ---------------------------------------------------------------

Line 4441: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

4437: ,p_parent_entity_result_id => l_out_cpp_result_id
4438: ) ;
4439:
4440: ---------------------------------------------------------------
4441: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
4442: ---------------------------------------------------------------
4443: --
4444: for l_parent_rec in c_peo2_from_parent(l_PLIP_ID) loop
4445: --

Line 4718: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------

4714: end loop;
4715: --
4716: end loop;
4717: ---------------------------------------------------------------
4718: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
4719: ---------------------------------------------------------------
4720: ---------------------------------------------------------------
4721: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
4722: ---------------------------------------------------------------