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_TIME_PERIODS

Line 56: FROM per_time_periods ptp

52: -- Returns the start DATE of the current period on the upload date.
53: CURSOR csr_period_start (p_assignment_id NUMBER
54: ,p_upload_date DATE) IS
55: SELECT nvl(ptp.start_date, end_of_time)
56: FROM per_time_periods ptp
57: ,per_assignments_f ass
58: WHERE ass.assignment_id = p_assignment_id
59: AND ptp.payroll_id = ass.payroll_id
60: AND p_upload_date between ass.effective_start_date and ass.effective_end_date