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_MANAGE_DEFAULT_ENRT dependencies on HR_API

Line 825: where nvl(asg.location_id,hr_api.g_number) =

821: and p_legal_entity_id is null
822: and p_payroll_id is null)
823: or exists (select null
824: from per_all_assignments_f asg
825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =

Line 826: nvl(p_location_id,hr_api.g_number)

822: and p_payroll_id is null)
823: or exists (select null
824: from per_all_assignments_f asg
825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)

Line 827: and nvl(asg.organization_id,hr_api.g_number) =

823: or exists (select null
824: from per_all_assignments_f asg
825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=

Line 828: nvl(p_organization_id,hr_api.g_number)

824: from per_all_assignments_f asg
825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=
832: nvl(p_payroll_id,hr_api.g_number)

Line 829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =

825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=
832: nvl(p_payroll_id,hr_api.g_number)
833: and asg.person_id = pil.person_id

Line 830: nvl(p_legal_entity_id,hr_api.g_number)

826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=
832: nvl(p_payroll_id,hr_api.g_number)
833: and asg.person_id = pil.person_id
834: and asg.primary_flag = 'Y'

Line 831: and nvl(asg.payroll_id, hr_api.g_number)=

827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=
832: nvl(p_payroll_id,hr_api.g_number)
833: and asg.person_id = pil.person_id
834: and asg.primary_flag = 'Y'
835: and asg.business_group_id = pil.business_group_id

Line 832: nvl(p_payroll_id,hr_api.g_number)

828: nvl(p_organization_id,hr_api.g_number)
829: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
830: nvl(p_legal_entity_id,hr_api.g_number)
831: and nvl(asg.payroll_id, hr_api.g_number)=
832: nvl(p_payroll_id,hr_api.g_number)
833: and asg.person_id = pil.person_id
834: and asg.primary_flag = 'Y'
835: and asg.business_group_id = pil.business_group_id
836: and l_effective_date

Line 1377: and nvl(pen.pgm_id,hr_api.g_number) = nvl(epe.pgm_id,hr_api.g_number)

1373: and not exists (select null from ben_prtt_enrt_rslt_f pen
1374: where pen.per_in_ler_id = epe.per_in_ler_id
1375: -- Bug 6319484 Instead of checking for same pen_id,
1376: -- check if not already enrolled in same plan
1377: and nvl(pen.pgm_id,hr_api.g_number) = nvl(epe.pgm_id,hr_api.g_number)
1378: --
1379: -- bug 10377891. If there are multiple options for a plan and one is
1380: -- a rollover that was automatically enrolled.
1381: --

Line 1386: and pen.effective_end_date = hr_api.g_eot

1382: and (pen.pl_id = epe.pl_id
1383: and pen.enrt_mthd_cd <> 'A') -- bug 10377891
1384: -- and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1385: and pen.prtt_enrt_rslt_stat_cd IS NULL
1386: and pen.effective_end_date = hr_api.g_eot
1387: and pen.enrt_cvg_thru_dt = hr_api.g_eot )
1388: order by epe.pgm_id, epe.pl_id;
1389:
1390: cursor c_test(c_pen_id number) is

Line 1387: and pen.enrt_cvg_thru_dt = hr_api.g_eot )

1383: and pen.enrt_mthd_cd <> 'A') -- bug 10377891
1384: -- and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1385: and pen.prtt_enrt_rslt_stat_cd IS NULL
1386: and pen.effective_end_date = hr_api.g_eot
1387: and pen.enrt_cvg_thru_dt = hr_api.g_eot )
1388: order by epe.pgm_id, epe.pl_id;
1389:
1390: cursor c_test(c_pen_id number) is
1391: select pen.prtt_enrt_rslt_id||'Y' from ben_prtt_enrt_rslt_f pen

Line 1430: and nvl(epe.pgm_id,hr_api.g_number) = nvl(c_pgm_id, hr_api.g_number)

1426: and epe.mndtry_flag = 'Y'
1427: and epe.Auto_enrt_flag = 'N'
1428: and epe.per_in_ler_id = p_per_in_ler_id
1429: and epe.Business_group_id = p_business_group_id
1430: and nvl(epe.pgm_id,hr_api.g_number) = nvl(c_pgm_id, hr_api.g_number)
1431: and epe.pl_id = c_pl_id
1432: and comp_lvl_cd = 'OIPL'; -- Bug 4951065
1433: --
1434: Cursor c_pen (lc_prtt_enrt_rslt_id number) is

Line 1640: AND nvl(l_pen.enrt_ovrid_thru_dt,hr_api.g_eot) >

1636: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);
1637: --
1638: -- 4684991 - Use lf_evt_ocrd_dt instead of p_effective_date
1639: if l_pen.enrt_ovridn_flag = 'Y'
1640: AND nvl(l_pen.enrt_ovrid_thru_dt,hr_api.g_eot) >
1641: NVL(l_global_pil_rec.lf_evt_ocrd_dt, p_effective_date) then
1642: --
1643: l_not_ovridn := false ;
1644: --

Line 1648: l_datetrack_mode := hr_api.g_correction;

1644: --
1645: end if ;
1646: --
1647: If (l_pen.effective_start_date = p_effective_date) then
1648: l_datetrack_mode := hr_api.g_correction;
1649: Else
1650: l_datetrack_mode := hr_api.g_update;
1651: End if;
1652: l_epe(i).actn_cd := 'UPD';

Line 1650: l_datetrack_mode := hr_api.g_update;

1646: --
1647: If (l_pen.effective_start_date = p_effective_date) then
1648: l_datetrack_mode := hr_api.g_correction;
1649: Else
1650: l_datetrack_mode := hr_api.g_update;
1651: End if;
1652: l_epe(i).actn_cd := 'UPD';
1653: Else
1654: l_datetrack_mode := hr_api.g_insert;

Line 1654: l_datetrack_mode := hr_api.g_insert;

1650: l_datetrack_mode := hr_api.g_update;
1651: End if;
1652: l_epe(i).actn_cd := 'UPD';
1653: Else
1654: l_datetrack_mode := hr_api.g_insert;
1655: l_epe(i).actn_cd := 'INS';
1656: End if;
1657:
1658: If(nvl(l_epe(i).dflt_flag,'X') = 'Y'

Line 1823: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then

1819: l_cryfwd_elig_dpnt_cd := substr(l_cryfwd_elig_dpnt_cd,1,l_prev_rslt_id_at-1) ;
1820: end if ;
1821:
1822:
1823: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1824:
1825: ben_automatic_enrollments.reinstate_dpnt
1826: (p_pgm_id => l_epe(i).pgm_id,
1827: p_pl_id => l_epe(i).pl_id,

Line 1848: and p_effective_date >= nvl(l_pen.ERLST_DEENRT_DT, hr_api.g_sot)

1844: p_susp_flag := TRUE;
1845: End if;
1846: Elsif(nvl(l_epe(i).dflt_flag,'X') <> 'Y'
1847: and nvl(l_epe(i).crntly_enrd_flag, 'X') = 'Y'
1848: and p_effective_date >= nvl(l_pen.ERLST_DEENRT_DT, hr_api.g_sot)
1849: and l_epe(i).AUTO_ENRT_FLAG = 'N'
1850: ) then
1851: --
1852: -- The enrollment result is ended in the multi_rows_edit. This