APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PER_ALL_ASSIGNMENTS_F

Line 856: FROM PER_ALL_ASSIGNMENTS_F paf --

852: d_progress := 70;
853:
854: SELECT nvl(paf.position_id, 0)
855: INTO x_auth_check_ids.position_id
856: FROM PER_ALL_ASSIGNMENTS_F paf --
857: WHERE paf.person_id = l_emp_id
858: AND paf.assignment_type IN ('E','C') --R12 CWK enhancement
859: AND paf.primary_flag = 'Y'
860: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 880: FROM PER_ALL_ASSIGNMENTS_F paf --

876: d_progress := 90;
877:
878: SELECT nvl(paf.job_id, 0)
879: INTO x_auth_check_ids.job_id
880: FROM PER_ALL_ASSIGNMENTS_F paf --
881: WHERE paf.person_id = l_emp_id
882: AND paf.assignment_type IN ('E','C') --R12 CWK enhancement
883: AND paf.primary_flag = 'Y'
884: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date;