APPS.BEN_CWB_EMP_ELIG dependencies on BEN_PER_IN_LER

Line 31: FROM ben_per_in_ler pil,

27: CURSOR c11
28: IS
29: SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
30: nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
31: FROM ben_per_in_ler pil,
32: ben_cwb_pl_dsgn dsgn
33: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
34: AND pil.group_pl_id = dsgn.group_pl_id
35: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt

Line 930: ben_per_in_ler pil

926: ,tran_tbl.attribute29 o4_person_rate_id
927: ,tran_tbl.attribute37 ovrd_person_id
928: ,pil.per_in_ler_stat_cd ler_stat
929: from ben_transaction tran_tbl,
930: ben_per_in_ler pil
931: where tran_tbl.attribute1 = itemkey
932: and tran_tbl.transaction_type = 'EMPELIGEMP'
933: and to_number(tran_tbl.attribute2) = pil.per_in_ler_id;
934: BEGIN