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 1372: ben_per_in_ler pil

1368: bpl.prtt_ro_of_unusd_amt_flag
1369: from ben_bnft_prvdd_ldgr_f bpl,
1370: ben_prtt_enrt_rslt_f pen,
1371: -- UK Changes.
1372: ben_per_in_ler pil
1373: where bpl.bnft_prvdd_ldgr_id=p_bnft_prvdd_ldgr_id and
1374: bpl.object_version_number=p_object_version_number and
1375: pen.prtt_enrt_rslt_id=bpl.prtt_enrt_rslt_id and
1376: pen.business_group_id=bpl.business_group_id and

Line 1390: FROM ben_per_in_ler pil, ben_ler_f ler

1386: -- Unable to use a parameter as this procedure is called from lot of places. hence queried again.
1387: --
1388: cursor c_cur_pil IS
1389: SELECT pil.per_in_ler_id
1390: FROM ben_per_in_ler pil, ben_ler_f ler
1391: WHERE pil.person_id = l_person_id
1392: and pil.ler_id = ler.ler_id
1393: AND pil.per_in_ler_stat_cd = 'STRTD'
1394: and p_effective_date between ler.effective_start_date