APPS.PER_PER_BUS dependencies on PER_PERIODS_OF_SERVICE

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

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

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

3366: --
3367: -- Description:
3368: -- - Validates that for person type of 'EMP','EMP_APL','EX_EMP' or
3369: -- 'EX_EMP_APL' the original date of hire is the same of earlier
3370: -- than the earliest per_periods_of_service start date.
3371: -- For any other person type a warning is raised if an original
3372: -- date of hire is entered.
3373: --
3374: -- Pre-conditions:

Line 3426: from per_periods_of_service

3422: l_earliest_date date;
3423: --
3424: cursor csr_earliest_date is
3425: select min(date_start)
3426: from per_periods_of_service
3427: where p_person_id = person_id;
3428:
3429: -- added for the bug 5402099
3430: l_earliest_date1 date;