eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BENEFIT_PRVDD_LEDGER_API dependencies on BEN_PER_IN_LER

Line 784: ben_per_in_ler pil

780: pen.enrt_mthd_cd
781: from ben_bnft_prvdd_ldgr_f bpl,
782: ben_prtt_enrt_rslt_f pen,
783: -- Bug : 1634870 : UK changes
784: ben_per_in_ler pil
785: where bpl.bnft_prvdd_ldgr_id=p_bnft_prvdd_ldgr_id and
786: bpl.object_version_number=p_object_version_number and
787: bpl.business_group_id=p_business_group_id and
788: pen.prtt_enrt_rslt_id=bpl.prtt_enrt_rslt_id and

Line 1378: ben_per_in_ler pil

1374: bpl.prtt_ro_of_unusd_amt_flag
1375: from ben_bnft_prvdd_ldgr_f bpl,
1376: ben_prtt_enrt_rslt_f pen,
1377: -- UK Changes.
1378: ben_per_in_ler pil
1379: where bpl.bnft_prvdd_ldgr_id=p_bnft_prvdd_ldgr_id and
1380: bpl.object_version_number=p_object_version_number and
1381: pen.prtt_enrt_rslt_id=bpl.prtt_enrt_rslt_id and
1382: pen.business_group_id=bpl.business_group_id and

Line 1396: FROM ben_per_in_ler pil, ben_ler_f ler

1392: -- Unable to use a parameter as this procedure is called from lot of places. hence queried again.
1393: --
1394: cursor c_cur_pil IS
1395: SELECT pil.per_in_ler_id
1396: FROM ben_per_in_ler pil, ben_ler_f ler
1397: WHERE pil.person_id = l_person_id
1398: and pil.ler_id = ler.ler_id
1399: AND pil.per_in_ler_stat_cd = 'STRTD'
1400: and p_effective_date between ler.effective_start_date