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

Line 654: pen.enrt_cvg_strt_dt and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot)

650: --(pen.pl_id=p_pl_id and pen.pgm_id is null))
651: and l_effective_date between
652: pen.effective_start_date and pen.effective_end_date
653: and l_effective_date between
654: pen.enrt_cvg_strt_dt and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot)
655: and ecd.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
656: and (nvl(ecd.ovrdn_flag,'N')='N' or
657: nvl(ecd.ovrdn_thru_dt,l_effective_date)>=l_effective_date)
658: and ecd.business_group_id = pen.business_group_id

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

672: /* and ( (p_location_id is null and p_organization_id is null
673: and p_legal_entity_id is null and p_payroll_id is null
674: ) or exists (select null
675: from per_assignments_f asg
676: where nvl(asg.location_id,hr_api.g_number) =
677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,

Line 677: nvl(p_location_id,hr_api.g_number)

673: and p_legal_entity_id is null and p_payroll_id is null
674: ) or exists (select null
675: from per_assignments_f asg
676: where nvl(asg.location_id,hr_api.g_number) =
677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =

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

674: ) or exists (select null
675: from per_assignments_f asg
676: where nvl(asg.location_id,hr_api.g_number) =
677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)

Line 679: nvl(p_organization_id,hr_api.g_number)

675: from per_assignments_f asg
676: where nvl(asg.location_id,hr_api.g_number) =
677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)
683: and nvl(asg.payroll_id, hr_api.g_number)=

Line 681: hr_api.g_number) =

677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)
683: and nvl(asg.payroll_id, hr_api.g_number)=
684: nvl(p_payroll_id,hr_api.g_number)
685: and asg.person_id = pen.person_id

Line 682: nvl(p_legal_entity_id,hr_api.g_number)

678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)
683: and nvl(asg.payroll_id, hr_api.g_number)=
684: nvl(p_payroll_id,hr_api.g_number)
685: and asg.person_id = pen.person_id
686: and asg.assignment_type <> 'C'

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

679: nvl(p_organization_id,hr_api.g_number)
680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)
683: and nvl(asg.payroll_id, hr_api.g_number)=
684: nvl(p_payroll_id,hr_api.g_number)
685: and asg.person_id = pen.person_id
686: and asg.assignment_type <> 'C'
687: and asg.primary_flag = 'Y'

Line 684: nvl(p_payroll_id,hr_api.g_number)

680: and nvl(asg.soft_coding_keyflex_id,
681: hr_api.g_number) =
682: nvl(p_legal_entity_id,hr_api.g_number)
683: and nvl(asg.payroll_id, hr_api.g_number)=
684: nvl(p_payroll_id,hr_api.g_number)
685: and asg.person_id = pen.person_id
686: and asg.assignment_type <> 'C'
687: and asg.primary_flag = 'Y'
688: and asg.business_group_id =

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

698: and p_payroll_id is null
699: )
700: or exists (select null
701: from per_assignments_f asg
702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =

Line 703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))

699: )
700: or exists (select null
701: from per_assignments_f asg
702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =
707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))

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

700: or exists (select null
701: from per_assignments_f asg
702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =
707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))
708: and asg.person_id = pen.person_id

Line 705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))

701: from per_assignments_f asg
702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =
707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))
708: and asg.person_id = pen.person_id
709: and asg.assignment_type <> 'C'

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

702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =
707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))
708: and asg.person_id = pen.person_id
709: and asg.assignment_type <> 'C'
710: and asg.primary_flag = 'Y'

Line 707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))

703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))
706: and nvl(asg.payroll_id,hr_api.g_number) =
707: nvl(p_payroll_id,nvl(asg.payroll_id,hr_api.g_number))
708: and asg.person_id = pen.person_id
709: and asg.assignment_type <> 'C'
710: and asg.primary_flag = 'Y'
711: and asg.business_group_id =

Line 807: hr_api.mandatory_arg_error(p_api_name => g_package

803: -- Check that all the mandatory input parameters
804: -- such as p_business_group_id, p_mode, p_effective_date
805: --
806: l_actn := 'Checking arguments...';
807: hr_api.mandatory_arg_error(p_api_name => g_package
808: ,p_argument => 'p_business_group_id'
809: ,p_argument_value => p_business_group_id
810: );
811: hr_api.mandatory_arg_error(p_api_name => g_package

Line 811: hr_api.mandatory_arg_error(p_api_name => g_package

807: hr_api.mandatory_arg_error(p_api_name => g_package
808: ,p_argument => 'p_business_group_id'
809: ,p_argument_value => p_business_group_id
810: );
811: hr_api.mandatory_arg_error(p_api_name => g_package
812: ,p_argument => 'p_effective_date'
813: ,p_argument_value => p_effective_date
814: );
815: --

Line 1249: hr_api.g_eot)

1245: and p_effective_date between
1246: pen.effective_start_date and pen.effective_end_date
1247: and p_effective_date between
1248: pen.enrt_cvg_strt_dt and nvl(pen.enrt_cvg_thru_dt,
1249: hr_api.g_eot)
1250: and ecd.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
1251: and ecd.business_group_id = pen.business_group_id
1252: and p_effective_date between
1253: ecd.effective_start_date and ecd.effective_end_date

Line 1533: -- nvl(l_rec.ovrdn_thru_dt,hr_api.g_eot) >= p_effective_date then --commented for bug 14552686

1529: -- overrided through enrollment override form then dependent coverage
1530: -- is not ending though the dependent became ineligible.
1531:
1532: if nvl(l_rec.ovrdn_flag,'N') = 'Y' and
1533: -- nvl(l_rec.ovrdn_thru_dt,hr_api.g_eot) >= p_effective_date then --commented for bug 14552686
1534: l_rec.ovrdn_thru_dt is not null and
1535: l_rec.ovrdn_thru_dt >= p_effective_date then -- code added for bug 14552686
1536:
1537: null;

Line 1567: l_datetrack_mode:=hr_api.g_correction;

1563: --
1564: -- Call api
1565: --
1566: if p_effective_date=l_rec.effective_start_date then
1567: l_datetrack_mode:=hr_api.g_correction;
1568: else
1569: l_datetrack_mode:=hr_api.g_update;
1570: end if;
1571: --

Line 1569: l_datetrack_mode:=hr_api.g_update;

1565: --
1566: if p_effective_date=l_rec.effective_start_date then
1567: l_datetrack_mode:=hr_api.g_correction;
1568: else
1569: l_datetrack_mode:=hr_api.g_update;
1570: end if;
1571: --
1572: -- According to the cursor, the coverage has started as of the
1573: -- effective date, so the coverage through date should atleast be

Line 1592: -- nvl(l_rec.ovrdn_thru_dt,hr_api.g_eot) >= p_effective_date then

1588: -- 14552686 - when dependent enrollment record(other than coverage thru date) is
1589: -- overrided through enrollment override form then dependent coverage
1590: -- is not ending though the dependent became ineligible.
1591: if nvl(l_rec.ovrdn_flag,'N') = 'Y' and
1592: -- nvl(l_rec.ovrdn_thru_dt,hr_api.g_eot) >= p_effective_date then
1593: l_rec.ovrdn_thru_dt is not null and
1594: l_rec.ovrdn_thru_dt >= p_effective_date then -- code added for bug 14552686
1595:
1596: null;