APPS.HR_PROCESS_CONTACT_SS dependencies on PER_PERIODS_OF_SERVICE

Line 14762: select max(date_start) into l_pds_date_start from per_periods_of_service

14758: select date_start into l_date_start from per_contact_relationships where
14759: contact_relationship_id = p_contact_relationship_id;
14760: end if;
14761: if (p_date_start < l_date_start or l_date_start = hr_api.g_date) then
14762: select max(date_start) into l_pds_date_start from per_periods_of_service
14763: where person_id = p_person_id;
14764: if l_pds_date_start > p_date_start then
14765: l_cov_date_start := l_pds_date_start;
14766: else