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_ACTN_F

Line 2101: -- ben_prtt_enrt_actn_f

2097: -- Following are the tables whose data will be compared to
2098: -- find any differences exists between the two runs of same ler.
2099: --
2100: -- ben_elig_cvrd_dpnt_f
2101: -- ben_prtt_enrt_actn_f
2102: -- ben_elig_per_elctbl_chc -- 9999 done
2103: -- ben_enrt_bnft
2104: -- ben_enrt_rt
2105: -- ben_elctbl_chc_ctfn

Line 2487: -- ben_prtt_enrt_actn_f

2483: -- Following are the tables whose data will be compared to
2484: -- find any differences exists between the two runs of same ler.
2485: --
2486: -- ben_elig_cvrd_dpnt_f
2487: -- ben_prtt_enrt_actn_f
2488: -- ben_elig_per_elctbl_chc
2489: -- ben_enrt_bnft
2490: -- ben_enrt_rt
2491: -- ben_elctbl_chc_ctfn

Line 4564: from ben_prtt_enrt_actn_f pea

4560: --
4561: cursor c_old_pea is
4562: select pea.CMPLTD_DT,
4563: pea.ACTN_TYP_ID
4564: from ben_prtt_enrt_actn_f pea
4565: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
4566: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4567: and pea.business_group_id = p_business_group_id
4568: and nvl(pea.pl_bnf_id, -1) = nvl(p_old_pl_bnf_id, -1)

Line 4588: and pea.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_ACTN_F'

4584: and nvl(pea.dpnt_person_id, -1) = nvl(p_old_elig_cvrd_dpnt_id, -1)
4585: -- dpnt_person_id used as elig_cvrd_dpnt_id
4586: -- and pea.ENRT_BNFT_ID is null -- used as pea.PL_BNF_ID
4587: -- and pea.DPNT_PERSON_ID is null -- used as ELIG_CVRD_DPNT_ID is null
4588: and pea.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_ACTN_F'
4589: order by 1; -- pbn.effective_end_date; -- Low to High
4590: --
4591: l_prtt_enrt_actn_id number(15);
4592: l_pea_effective_start_date date;

Line 4598: from ben_prtt_enrt_actn_f pea

4594: l_pea_object_version_number number(9);
4595: --
4596: cursor c_pea(cp_actn_typ_id in number) is
4597: select pea.*
4598: from ben_prtt_enrt_actn_f pea
4599: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4600: and pea.actn_typ_id = cp_actn_typ_id
4601: and pea.business_group_id = p_business_group_id
4602: and pea.per_in_ler_id = p_per_in_ler_id

Line 4689: from ben_prtt_enrt_actn_f pea,

4685: cursor c_old_cpp is
4686: select cpp.DPNT_DSGN_CTFN_RECD_DT,
4687: pea.ACTN_TYP_ID,
4688: cpp.DPNT_DSGN_CTFN_TYP_CD
4689: from ben_prtt_enrt_actn_f pea,
4690: ben_cvrd_dpnt_ctfn_prvdd_f cpp
4691: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
4692: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4693: and pea.business_group_id = p_business_group_id

Line 4710: from ben_prtt_enrt_actn_f pea,

4706: --
4707: cursor c_cpp(cp_actn_typ_id in number,
4708: cp_DPNT_DSGN_CTFN_TYP_CD in varchar2) is
4709: select cpp.*
4710: from ben_prtt_enrt_actn_f pea,
4711: ben_cvrd_dpnt_ctfn_prvdd_f cpp
4712: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4713: and pea.actn_typ_id = cp_actn_typ_id
4714: and pea.business_group_id = p_business_group_id

Line 5256: from ben_prtt_enrt_actn_f pea,

5252: cursor c_old_pbc is
5253: select pbc.BNF_CTFN_RECD_DT,
5254: pea.ACTN_TYP_ID,
5255: pbc.BNF_CTFN_TYP_CD
5256: from ben_prtt_enrt_actn_f pea,
5257: ben_pl_bnf_ctfn_prvdd_f pbc
5258: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
5259: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5260: and pea.business_group_id = p_business_group_id

Line 5274: from ben_prtt_enrt_actn_f pea,

5270: --
5271: cursor c_pbc(cp_actn_typ_id in number,
5272: cp_BNF_CTFN_TYP_CD in varchar2) is
5273: select pbc.*
5274: from ben_prtt_enrt_actn_f pea,
5275: ben_pl_bnf_ctfn_prvdd_f pbc
5276: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5277: and pea.actn_typ_id = cp_actn_typ_id
5278: and pea.business_group_id = p_business_group_id

Line 5868: ben_prtt_enrt_actn_f pea

5864: --
5865: cursor c_old_pcs is
5866: select pcs.*, pea.ACTN_TYP_ID
5867: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5868: ben_prtt_enrt_actn_f pea
5869: where pcs.prtt_enrt_actn_id = pea.prtt_enrt_actn_id
5870: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5871: and pea.per_in_ler_id = p_bckdt_per_in_ler_id
5872: and pea.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id

Line 5885: ben_prtt_enrt_actn_f pea

5881: reinstating the certification record.*/
5882: union
5883: select pcs.*, pea.ACTN_TYP_ID
5884: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5885: ben_prtt_enrt_actn_f pea
5886: where pcs.prtt_enrt_actn_id = pea.prtt_enrt_actn_id
5887: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5888: and pea.per_in_ler_id = p_bckdt_per_in_ler_id
5889: and pea.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id

Line 5891: and pea.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_actn_f pea1

5887: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5888: and pea.per_in_ler_id = p_bckdt_per_in_ler_id
5889: and pea.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id
5890: and pcs.business_group_id = p_business_group_id
5891: and pea.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_actn_f pea1
5892: where pea1.per_in_ler_id = pea.per_in_ler_id
5893: and pea1.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
5894: and pea1.prtt_enrt_actn_id = pea.prtt_enrt_actn_id)
5895: and pcs.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_ctfn_prvdd_f pcs1

Line 5908: ben_prtt_enrt_actn_f pea

5904: cp_ENRT_R_BNFT_CTFN_CD in varchar2,
5905: cp_ACTN_TYP_ID in varchar2) is
5906: select pcs.*
5907: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5908: ben_prtt_enrt_actn_f pea
5909: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5910: and nvl(pcs.enrt_ctfn_typ_cd, -1) = nvl(cp_enrt_ctfn_typ_cd, -1)
5911: and nvl(pcs.enrt_r_bnft_ctfn_cd, -1) = nvl(cp_enrt_r_bnft_ctfn_cd, -1)
5912: and pea.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id