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.PAY_ES_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 94: FROM per_all_assignments_f ass

90: end_date DATE;
91: CURSOR csr_payroll_start_date (p_assignment_id NUMBER
92: ,p_upload_date DATE) IS
93: SELECT nvl(ppf.effective_start_date, end_of_time)
94: FROM per_all_assignments_f ass
95: ,pay_all_payrolls_f ppf
96: WHERE ass.assignment_id = p_assignment_id
97: AND p_upload_date BETWEEN
98: nvl(ass.effective_start_date,p_upload_date) AND

Line 297: FROM per_all_assignments_f paaf

293: ,p_effective_date DATE) RETURN NUMBER IS
294: --
295: CURSOR csr_get_wc_details IS
296: SELECT scl.segment2 work_center
297: FROM per_all_assignments_f paaf
298: ,hr_soft_coding_keyflex scl
299: WHERE paaf.assignment_id = p_assignment_id
300: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
301: AND p_effective_date BETWEEN effective_start_date