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 811: where nvl(asg.location_id,hr_api.g_number) =

807: and p_legal_entity_id is null
808: and p_payroll_id is null)
809: or exists (select null
810: from per_all_assignments_f asg
811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =

Line 812: nvl(p_location_id,hr_api.g_number)

808: and p_payroll_id is null)
809: or exists (select null
810: from per_all_assignments_f asg
811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)

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

809: or exists (select null
810: from per_all_assignments_f asg
811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=

Line 814: nvl(p_organization_id,hr_api.g_number)

810: from per_all_assignments_f asg
811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=
818: nvl(p_payroll_id,hr_api.g_number)

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

811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=
818: nvl(p_payroll_id,hr_api.g_number)
819: and asg.person_id = pil.person_id

Line 816: nvl(p_legal_entity_id,hr_api.g_number)

812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=
818: nvl(p_payroll_id,hr_api.g_number)
819: and asg.person_id = pil.person_id
820: and asg.primary_flag = 'Y'

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

813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=
818: nvl(p_payroll_id,hr_api.g_number)
819: and asg.person_id = pil.person_id
820: and asg.primary_flag = 'Y'
821: and asg.business_group_id = pil.business_group_id

Line 818: nvl(p_payroll_id,hr_api.g_number)

814: nvl(p_organization_id,hr_api.g_number)
815: and nvl(asg.soft_coding_keyflex_id,hr_api.g_number) =
816: nvl(p_legal_entity_id,hr_api.g_number)
817: and nvl(asg.payroll_id, hr_api.g_number)=
818: nvl(p_payroll_id,hr_api.g_number)
819: and asg.person_id = pil.person_id
820: and asg.primary_flag = 'Y'
821: and asg.business_group_id = pil.business_group_id
822: and l_effective_date

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

1338: and not exists (select null from ben_prtt_enrt_rslt_f pen
1339: where pen.per_in_ler_id = epe.per_in_ler_id
1340: -- Bug 6319484 Instead of checking for same pen_id,
1341: -- check if not already enrolled in same plan
1342: and nvl(pen.pgm_id,hr_api.g_number) = nvl(epe.pgm_id,hr_api.g_number)
1343: and pen.pl_id = epe.pl_id
1344: -- and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1345: and pen.prtt_enrt_rslt_stat_cd IS NULL
1346: and pen.effective_end_date = hr_api.g_eot

Line 1346: and pen.effective_end_date = hr_api.g_eot

1342: and nvl(pen.pgm_id,hr_api.g_number) = nvl(epe.pgm_id,hr_api.g_number)
1343: and pen.pl_id = epe.pl_id
1344: -- and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1345: and pen.prtt_enrt_rslt_stat_cd IS NULL
1346: and pen.effective_end_date = hr_api.g_eot
1347: and pen.enrt_cvg_thru_dt = hr_api.g_eot )
1348: order by epe.pgm_id, epe.pl_id;
1349:
1350: Cursor c_dflt_mn_epe_mndtry (c_pgm_id number, c_pl_id number) is

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

1343: and pen.pl_id = epe.pl_id
1344: -- and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1345: and pen.prtt_enrt_rslt_stat_cd IS NULL
1346: and pen.effective_end_date = hr_api.g_eot
1347: and pen.enrt_cvg_thru_dt = hr_api.g_eot )
1348: order by epe.pgm_id, epe.pl_id;
1349:
1350: Cursor c_dflt_mn_epe_mndtry (c_pgm_id number, c_pl_id number) is
1351: Select epe.ELIG_PER_ELCTBL_CHC_ID

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

1372: and epe.mndtry_flag = 'Y'
1373: and epe.Auto_enrt_flag = 'N'
1374: and epe.per_in_ler_id = p_per_in_ler_id
1375: and epe.Business_group_id = p_business_group_id
1376: and nvl(epe.pgm_id,hr_api.g_number) = nvl(c_pgm_id, hr_api.g_number)
1377: and epe.pl_id = c_pl_id
1378: and comp_lvl_cd = 'OIPL'; -- Bug 4951065
1379: --
1380: Cursor c_pen (lc_prtt_enrt_rslt_id number) is

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

1543: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);
1544: --
1545: -- 4684991 - Use lf_evt_ocrd_dt instead of p_effective_date
1546: if l_pen.enrt_ovridn_flag = 'Y'
1547: AND nvl(l_pen.enrt_ovrid_thru_dt,hr_api.g_eot) >
1548: NVL(l_global_pil_rec.lf_evt_ocrd_dt, p_effective_date) then
1549: --
1550: l_not_ovridn := false ;
1551: --

Line 1555: l_datetrack_mode := hr_api.g_correction;

1551: --
1552: end if ;
1553: --
1554: If (l_pen.effective_start_date = p_effective_date) then
1555: l_datetrack_mode := hr_api.g_correction;
1556: Else
1557: l_datetrack_mode := hr_api.g_update;
1558: End if;
1559: l_epe(i).actn_cd := 'UPD';

Line 1557: l_datetrack_mode := hr_api.g_update;

1553: --
1554: If (l_pen.effective_start_date = p_effective_date) then
1555: l_datetrack_mode := hr_api.g_correction;
1556: Else
1557: l_datetrack_mode := hr_api.g_update;
1558: End if;
1559: l_epe(i).actn_cd := 'UPD';
1560: Else
1561: l_datetrack_mode := hr_api.g_insert;

Line 1561: l_datetrack_mode := hr_api.g_insert;

1557: l_datetrack_mode := hr_api.g_update;
1558: End if;
1559: l_epe(i).actn_cd := 'UPD';
1560: Else
1561: l_datetrack_mode := hr_api.g_insert;
1562: l_epe(i).actn_cd := 'INS';
1563: End if;
1564:
1565: If(nvl(l_epe(i).dflt_flag,'X') = 'Y'

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

1700: l_cryfwd_elig_dpnt_cd := substr(l_cryfwd_elig_dpnt_cd,1,l_prev_rslt_id_at-1) ;
1701: end if ;
1702:
1703:
1704: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1705:
1706: ben_automatic_enrollments.reinstate_dpnt
1707: (p_pgm_id => l_epe(i).pgm_id,
1708: p_pl_id => l_epe(i).pl_id,

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

1725: p_susp_flag := TRUE;
1726: End if;
1727: Elsif(nvl(l_epe(i).dflt_flag,'X') <> 'Y'
1728: and nvl(l_epe(i).crntly_enrd_flag, 'X') = 'Y'
1729: and p_effective_date >= nvl(l_pen.ERLST_DEENRT_DT, hr_api.g_sot)
1730: and l_epe(i).AUTO_ENRT_FLAG = 'N'
1731: ) then
1732: --
1733: -- The enrollment result is ended in the multi_rows_edit. This