APPS.BEN_DETERMINE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 255: FROM ben_elig_per_elctbl_chc b

251: AND b.elig_per_elctbl_chc_id = l_elctbl_chc_id;
252: CURSOR c_elig_per_elctbl_chc(
253: l_per_in_ler NUMBER) IS
254: SELECT b.elig_per_elctbl_chc_id
255: FROM ben_elig_per_elctbl_chc b
256: WHERE b.per_in_ler_id = l_per_in_ler
257: AND ( b.pgm_id = p_pgm_id
258: OR pgm_id IS NULL)
259: AND ( b.pl_id = p_pl_id

Line 1796: FROM ben_elig_per_elctbl_chc epe,

1792: pel.lee_rsn_id,
1793: pel.acty_ref_perd_cd,
1794: pil.ler_id,
1795: pil.person_id
1796: FROM ben_elig_per_elctbl_chc epe,
1797: ben_pil_elctbl_chc_popl pel,
1798: ben_enrt_bnft enb,
1799: ben_per_in_ler pil
1800: WHERE epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id (+)