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
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
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
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: ---------------------------------------------------------------
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
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
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
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: ---------------------------------------------------------------
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
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
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
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: ---------------------------------------------------------------
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: --
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: ---------------------------------------------------------------
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 ----------------------
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: ---------------------------------------------------------------
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: --
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: ---------------------------------------------------------------