APPS.BEN_DETERMINE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 257: FROM ben_elig_per_elctbl_chc b

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

Line 1798: FROM ben_elig_per_elctbl_chc epe,

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