APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_ELIG_PER_F

Line 498: ben_elig_per_f pep,

494: cursor c_dpnt_usage is
495: select ctu.cm_typ_usg_id,
496: ctu.cm_usg_rl
497: from ben_cm_typ_usg_f ctu,
498: ben_elig_per_f pep,
499: ben_enrt_perd enp,
500: ben_popl_enrt_typ_cycl_f pet
501: where ctu.business_group_id = p_business_group_id
502: /* First join comp objects */

Line 554: ben_elig_per_f pep,

550: cursor c_rltd_per_usage is
551: select ctu.cm_typ_usg_id,
552: ctu.cm_usg_rl
553: from ben_cm_typ_usg_f ctu,
554: ben_elig_per_f pep,
555: ben_enrt_perd enp,
556: ben_popl_enrt_typ_cycl_f pet
557: where ctu.business_group_id = p_business_group_id
558: /* First join comp objects */

Line 622: from ben_elig_per_f pep

618: and pen.per_in_ler_id = pdp.per_in_ler_id);
619: --
620: cursor c_dpnt_always is
621: select null
622: from ben_elig_per_f pep
623: where pep.business_group_id = p_business_group_id
624: and pep.person_id = p_person_id
625: and p_effective_date
626: between pep.effective_start_date

Line 653: ben_elig_per_f pep,

649: cursor c_bnf_usage is
650: select ctu.cm_typ_usg_id,
651: ctu.cm_usg_rl
652: from ben_cm_typ_usg_f ctu,
653: ben_elig_per_f pep,
654: ben_enrt_perd enp,
655: ben_popl_enrt_typ_cycl_f pet
656: where ctu.business_group_id = p_business_group_id
657: /* First join comp objects */

Line 721: from ben_elig_per_f pep

717: and pen.per_in_ler_id = pbn.per_in_ler_id);
718: --
719: cursor c_bnf_always is
720: select null
721: from ben_elig_per_f pep
722: where pep.business_group_id = p_business_group_id
723: and pep.person_id = p_person_id
724: and p_effective_date
725: between pep.effective_start_date