DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG_V2 dependencies on PER_PERSON_TYPES

Line 403: FROM per_people_f ppf, per_person_types ppt

399: ( p_person_id per_all_people_f.person_id%TYPE
400: , p_current_hire_date DATE)
401: IS
402: SELECT effective_start_date
403: FROM per_people_f ppf, per_person_types ppt
404: WHERE ppf.person_id = p_person_id
405: AND ppf.person_type_id = ppt.person_type_id
406: AND ppf.effective_start_date > p_current_hire_date;
407: BEGIN