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_SE_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 43: ,per_assignments_f ASS

39: , p_upload_date DATE
40: ) IS
41: SELECT NVL(PTP.start_date, END_OF_TIME)
42: FROM per_time_periods PTP
43: ,per_assignments_f ASS
44: WHERE ASS.assignment_id = p_assignment_id
45: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
46: AND PTP.payroll_id = ASS.payroll_id
47: AND p_upload_date BETWEEN PTP.start_date AND PTP.end_date;

Line 54: FROM per_assignments_f ASS

50: , p_upload_date DATE
51: , p_expiry_date DATE
52: ) IS
53: SELECT NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
54: FROM per_assignments_f ASS
55: WHERE ASS.assignment_id = p_assignment_id
56: AND ASS.effective_start_date <= p_upload_date
57: AND ASS.effective_end_date >= p_expiry_date;
58: