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_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PRTT_ENRT_ACTN_F

Line 7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type

3: --
4: -- Globle Type declaration
5: --
6: type g_actn_rec is record
7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type
8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type

Line 8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type

4: -- Globle Type declaration
5: --
6: type g_actn_rec is record
7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type
8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type
12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type

Line 9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type

5: --
6: type g_actn_rec is record
7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type
8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type
12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type
13: ,actn_cd varchar2(30)

Line 10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type

6: type g_actn_rec is record
7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type
8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type
12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type
13: ,actn_cd varchar2(30)
14: ,effective_start_date date

Line 11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type

7: (prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type
8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type
12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type
13: ,actn_cd varchar2(30)
14: ,effective_start_date date
15: ,effective_end_date date

Line 12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type

8: ,cmpltd_dt ben_prtt_enrt_actn_f.cmpltd_dt%type
9: ,due_dt ben_prtt_enrt_actn_f.due_dt%type
10: ,rqd_flag ben_prtt_enrt_actn_f.rqd_flag%type
11: ,prtt_enrt_rslt_id ben_prtt_enrt_actn_f.prtt_enrt_rslt_id%type
12: ,actn_typ_id ben_prtt_enrt_actn_f.actn_typ_id%type
13: ,actn_cd varchar2(30)
14: ,effective_start_date date
15: ,effective_end_date date
16: );

Line 505: ,ben_prtt_enrt_actn_f b

501: Select a.prtt_enrt_rslt_id,
502: b.actn_typ_id,
503: a.enrt_ctfn_recd_dt
504: from ben_prtt_enrt_ctfn_prvdd_f a
505: ,ben_prtt_enrt_actn_f b
506: ,ben_per_in_ler pil
507: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
508: and a.business_group_id= p_business_group_Id
509: and p_effective_date between

Line 565: from ben_prtt_enrt_actn_f pea,

561: ,pea.actn_typ_id
562: ,'N' actn_cd
563: ,pea.effective_start_date
564: ,pea.effective_end_date
565: from ben_prtt_enrt_actn_f pea,
566: ben_per_in_ler pil
567: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
568: and pea.business_group_id = p_business_group_id
569: and p_effective_date between pea.effective_start_date

Line 668: from ben_prtt_enrt_actn_f pea

664: where pen.person_id = p_person_id
665: and pen.business_group_id = p_business_group_id
666: and pen.prtt_enrt_rslt_stat_cd is null
667: and exists (select null
668: from ben_prtt_enrt_actn_f pea
669: where pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
670: and pea.cmpltd_dt is null
671: and p_effective_date between pea.effective_start_date
672: and pea.effective_end_date)

Line 700: from ben_prtt_enrt_actn_f b,

696: ,b.actn_typ_id
697: ,b.effective_start_date
698: ,b.effective_end_date
699: ,b.object_version_number
700: from ben_prtt_enrt_actn_f b,
701: ben_per_in_ler pil
702: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
703: and b.business_group_id = p_business_group_id
704: and b.cmpltd_dt is NULL

Line 717: from ben_prtt_enrt_actn_f b,

713: --
714: cursor c_actn_min (c_prtt_enrt_rslt_id number)
715: is
716: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
717: from ben_prtt_enrt_actn_f b,
718: ben_per_in_ler pil
719: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
720: and b.business_group_id = p_business_group_id
721: and b.cmpltd_dt is NULL

Line 1733: ,ben_prtt_enrt_actn_f actn

1729: is
1730: select distinct pen.person_id
1731: from ben_prtt_enrt_rslt_f pen
1732: ,ben_per_in_ler pil
1733: ,ben_prtt_enrt_actn_f actn
1734: where pen.business_group_id = p_business_group_id
1735: and pen.business_group_id = actn.business_group_id
1736: and pen.prtt_enrt_rslt_stat_cd is null
1737: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id