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: /* Bug 10145083: Check for c_effective_date and not p_effective_date*/

Line 673: from ben_prtt_enrt_actn_f pea

669: where pen.person_id = p_person_id
670: and pen.business_group_id = p_business_group_id
671: and pen.prtt_enrt_rslt_stat_cd is null
672: and exists (select null
673: from ben_prtt_enrt_actn_f pea
674: where pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
675: and pea.cmpltd_dt is null
676: and p_effective_date between pea.effective_start_date
677: and pea.effective_end_date)

Line 705: from ben_prtt_enrt_actn_f b,

701: ,b.actn_typ_id
702: ,b.effective_start_date
703: ,b.effective_end_date
704: ,b.object_version_number
705: from ben_prtt_enrt_actn_f b,
706: ben_per_in_ler pil
707: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
708: and b.business_group_id = p_business_group_id
709: and b.cmpltd_dt is NULL

Line 810: from ben_prtt_enrt_actn_f b,

806: --
807: cursor c_actn_min (c_prtt_enrt_rslt_id number)
808: is
809: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
810: from ben_prtt_enrt_actn_f b,
811: ben_per_in_ler pil
812: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
813: and b.business_group_id = p_business_group_id
814: and b.cmpltd_dt is NULL

Line 1873: ,ben_prtt_enrt_actn_f actn

1869: is
1870: select distinct pen.person_id
1871: from ben_prtt_enrt_rslt_f pen
1872: ,ben_per_in_ler pil
1873: ,ben_prtt_enrt_actn_f actn
1874: where pen.business_group_id = p_business_group_id
1875: and pen.business_group_id = actn.business_group_id
1876: and pen.prtt_enrt_rslt_stat_cd is null
1877: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id