[Home] [Help]
50: p_ler_id => p_ler_id,
51: p_business_group_id => p_business_group_id,
52: p_assignment_id => p_assignment_id,
53: --RCHASE Bug Fix - Formula requires person_id as input value
54: --RCHASE for individuals without assignments
55: p_param1 =>'PERSON_ID',
56: p_param1_value =>to_char(p_rcpent_person_id)
57: );
58: --
2578: nvl(ctu.pl_id,pen.pl_id));
2579: --
2580: cursor c_bnf_always is
2581: select null
2582: from sys.dual
2583: where exists (select null
2584: from ben_pl_bnf_f pbn,
2585: ben_prtt_enrt_rslt_f pen,
2586: ben_prtt_enrt_actn_f pea
2651: nvl(ctu.pl_id,pen.pl_id));
2652: --
2653: cursor c_dpnt_always is
2654: select null
2655: from sys.dual
2656: where exists (select null
2657: from ben_elig_cvrd_dpnt_f pdp,
2658: ben_prtt_enrt_rslt_f pen,
2659: ben_prtt_enrt_actn_f pea
3135: nvl(ctu.pl_id,pen.pl_id));
3136: --
3137: cursor c_dpnt_always is
3138: select null
3139: from sys.dual
3140: where exists (select null
3141: from ben_elig_cvrd_dpnt_f pdp,
3142: ben_prtt_enrt_rslt_f pen
3143: where pdp.business_group_id = p_business_group_id
3190: nvl(ctu.pl_id,pen.pl_id));
3191: --
3192: cursor c_bnf_always is
3193: select null
3194: from sys.dual
3195: where exists (select null
3196: from ben_pl_bnf_f pbn,
3197: ben_prtt_enrt_rslt_f pen
3198: where pbn.business_group_id = p_business_group_id
3489: and pdp.per_in_ler_id = pel.per_in_ler_id);
3490: --
3491: cursor c_dpnt_always is
3492: select null
3493: from sys.dual
3494: where exists (select null
3495: from ben_elig_cvrd_dpnt_f pdp
3496: where pdp.business_group_id = p_business_group_id
3497: and pdp.dpnt_person_id = p_rcpent_person_id
3546: and pbn.per_in_ler_id = pel.per_in_ler_id);
3547: --
3548: cursor c_bnf_always is
3549: select null
3550: from sys.dual
3551: where exists (select null
3552: from ben_pl_bnf_f pbn
3553: where pbn.business_group_id = p_business_group_id
3554: and pbn.bnf_person_id = p_rcpent_person_id
3819: nvl(ctu.pl_id,pen.pl_id));
3820: --
3821: cursor c_dpnt_always is
3822: select null
3823: from sys.dual
3824: where exists (select null
3825: from ben_elig_cvrd_dpnt_f pdp,
3826: ben_prtt_enrt_rslt_f pen
3827: where pdp.business_group_id = p_business_group_id
3875: nvl(ctu.pl_id,pen.pl_id));
3876: --
3877: cursor c_bnf_always is
3878: select null
3879: from sys.dual
3880: where exists (select null
3881: from ben_pl_bnf_f pbn,
3882: ben_prtt_enrt_rslt_f pen
3883: where pbn.business_group_id = p_business_group_id