APPS.HR_PROCESS_CONTACT_SS dependencies on PER_PERIODS_OF_SERVICE

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

14926: select date_start into l_date_start from per_contact_relationships where
14927: contact_relationship_id = p_contact_relationship_id;
14928: end if;
14929: if (p_date_start < l_date_start or l_date_start = hr_api.g_date) then
14930: select max(date_start) into l_pds_date_start from per_periods_of_service
14931: where person_id = p_person_id;
14932: if l_pds_date_start > p_date_start then
14933: l_cov_date_start := l_pds_date_start;
14934: else