DBA Data[Home] [Help]

APPS.PQH_PROCESS_EMP_REVIEW dependencies on PER_ALL_PEOPLE_F

Line 41: per_all_people_f pf

37: where abc.transaction_step_id = p_transaction_step_id
38: and abc.name like 'P_EMPLOYEE_NO%'
39: ) x
40: ) reviewer,
41: per_all_people_f pf
42: WHERE pf.person_id = reviewer.person_id
43: AND (p_show_deleted = 'Y' or NVL(status,'E') <> 'D' ) -- Don't show deleted reviewers
44: AND SYSDATE BETWEEN pf.effective_start_date AND pf.effective_end_date;
45: