DBA Data[Home] [Help]

APPS.PSP_WF_ADJ_PKG dependencies on PER_ALL_PEOPLE_F

Line 58: FROM per_all_people_f ppf

54: BEGIN
55: SELECT count(*)
56: INTO l_valid_supervisor
57: -- FROM per_people_f ppf Commented for Bug 3741272
58: FROM per_all_people_f ppf
59: WHERE ppf.person_id = p_supervisor_id
60: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
61: AND current_employee_flag = 'Y';
62: