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_LF_EVT_CLPS_RESTORE dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 5496: from ben_prtt_enrt_ctfn_prvdd_f pcs,

5492: l_proc varchar2(72) := g_package || '.reinstate_pcs_per_pen';
5493: --
5494: cursor c_old_pcs is
5495: select pcs.*, pea.ACTN_TYP_ID
5496: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5497: ben_prtt_enrt_actn_f pea
5498: where pcs.prtt_enrt_actn_id = pea.prtt_enrt_actn_id
5499: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5500: and pea.per_in_ler_id = p_bckdt_per_in_ler_id

Line 5516: from ben_prtt_enrt_ctfn_prvdd_f pcs,

5512: cursor c_pcs(cp_enrt_ctfn_typ_cd in varchar2,
5513: cp_ENRT_R_BNFT_CTFN_CD in varchar2,
5514: cp_ACTN_TYP_ID in varchar2) is
5515: select pcs.*
5516: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5517: ben_prtt_enrt_actn_f pea
5518: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5519: and nvl(pcs.enrt_ctfn_typ_cd, -1) = nvl(cp_enrt_ctfn_typ_cd, -1)
5520: and nvl(pcs.enrt_r_bnft_ctfn_cd, -1) = nvl(cp_enrt_r_bnft_ctfn_cd, -1)