APPS.BEN_DET_ENRT_RATES dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 126: ben_bnft_prvdd_ldgr_f ldgr,

122: pen.enrt_mthd_cd = 'E' and
123: exists (select null
124: from ben_bnft_pool_rlovr_rqmt_f rlovr,
125: ben_prtt_enrt_rslt_f pen1,
126: ben_bnft_prvdd_ldgr_f ldgr,
127: ben_acty_base_rt_f abr
128: where pen1.pgm_id = pen.pgm_id
129: and pen1.comp_lvl_cd = 'PLANFC'
130: and pen1.per_in_ler_id = pen.per_in_ler_id

Line 1007: from ben_bnft_prvdd_ldgr_f bpl,

1003: ,p_acty_base_rt_id number
1004: ,p_per_in_ler_id number) is
1005: select bpl.bnft_prvdd_ldgr_id,
1006: bpl.object_version_number
1007: from ben_bnft_prvdd_ldgr_f bpl,
1008: ben_per_in_ler pil
1009: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1010: and bpl.acty_base_rt_id = p_acty_base_rt_id
1011: and bpl.used_val is not null

Line 1297: from ben_bnft_prvdd_ldgr_f bpl,

1293: ,p_acty_base_rt_id number
1294: ,p_per_in_ler_id number) is
1295: select bpl.bnft_prvdd_ldgr_id,
1296: bpl.object_version_number
1297: from ben_bnft_prvdd_ldgr_f bpl,
1298: ben_per_in_ler pil
1299: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1300: and bpl.acty_base_rt_id = p_acty_base_rt_id
1301: and bpl.used_val is not null