eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 542: FROM per_all_assignments_f

538: c_effective_date DATE
539: )
540: IS
541: SELECT employment_category
542: FROM per_all_assignments_f
543: WHERE assignment_id = c_assignment_id
544: AND c_effective_date BETWEEN effective_start_date
545: AND effective_end_date
546: ORDER BY effective_start_date DESC;

Line 552: FROM per_all_assignments_f

548: -- CURSOR to get person_id and assignment_number
549: CURSOR csr_get_asg_details (c_assignment_id NUMBER, c_effective_date DATE)
550: IS
551: SELECT person_id, assignment_number, employee_category
552: FROM per_all_assignments_f
553: WHERE assignment_id = c_assignment_id
554: AND c_effective_date BETWEEN effective_start_date
555: AND effective_end_date
556: ORDER BY effective_start_date DESC;