APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PER_ALL_ASSIGNMENTS_F

Line 872: FROM PER_ALL_ASSIGNMENTS_F paf --

868: d_progress := 70;
869:
870: SELECT nvl(paf.position_id, 0)
871: INTO x_auth_check_ids.position_id
872: FROM PER_ALL_ASSIGNMENTS_F paf --
873: WHERE paf.person_id = l_emp_id
874: AND paf.assignment_type IN ('E','C') --R12 CWK enhancement
875: AND paf.primary_flag = 'Y'
876: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 896: FROM PER_ALL_ASSIGNMENTS_F paf --

892: d_progress := 90;
893:
894: SELECT nvl(paf.job_id, 0)
895: INTO x_auth_check_ids.job_id
896: FROM PER_ALL_ASSIGNMENTS_F paf --
897: WHERE paf.person_id = l_emp_id
898: AND paf.assignment_type IN ('E','C') --R12 CWK enhancement
899: AND paf.primary_flag = 'Y'
900: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date;