APPS.PER_PER_BUS dependencies on PER_PERIODS_OF_SERVICE

Line 1726: ,p_start_date in per_periods_of_service.date_start%TYPE)

1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1725: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1726: ,p_start_date in per_periods_of_service.date_start%TYPE)
1727: is
1728: --
1729: l_exists varchar2(1);
1730: l_proc varchar2(72) := g_package||'chk_employee_number';

Line 3380: -- than the earliest per_periods_of_service start date.

3376: --
3377: -- Description:
3378: -- - Validates that for person type of 'EMP','EMP_APL','EX_EMP' or
3379: -- 'EX_EMP_APL' the original date of hire is the same of earlier
3380: -- than the earliest per_periods_of_service start date.
3381: -- For any other person type a warning is raised if an original
3382: -- date of hire is entered.
3383: --
3384: -- Pre-conditions:

Line 3436: from per_periods_of_service

3432: l_earliest_date date;
3433: --
3434: cursor csr_earliest_date is
3435: select min(date_start)
3436: from per_periods_of_service
3437: where p_person_id = person_id;
3438:
3439: -- added for the bug 5402099
3440: l_earliest_date1 date;