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_IN_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 46: FROM per_time_periods PTP

42: CURSOR csr_period_start( p_assignment_id NUMBER
43: , p_upload_date DATE
44: ) IS
45: SELECT NVL(PTP.start_date, END_OF_TIME)
46: FROM per_time_periods PTP
47: ,per_assignments_f ASS
48: WHERE ASS.assignment_id = p_assignment_id
49: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
50: AND PTP.payroll_id = ASS.payroll_id

Line 59: ,per_time_periods PTP ----bug 15844819

55: , p_expiry_date DATE
56: ) IS
57: SELECT NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
58: FROM per_assignments_f ASS
59: ,per_time_periods PTP ----bug 15844819
60: WHERE ASS.assignment_id = p_assignment_id
61: AND ASS.assignment_type in ('E','B','C') ----bug 15844819
62: AND PTP.payroll_id = ASS.payroll_id
63: AND ASS.effective_start_date between PTP.start_date and PTP.end_date