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

Line 38: FROM per_time_periods TP

34: CURSOR cur_end_date ( p_pactid NUMBER
35: , p_date DATE
36: ) IS
37: SELECT TP.end_date + 1
38: FROM per_time_periods TP
39: , pay_payroll_actions PACT
40: WHERE PACT.payroll_action_id = p_pactid
41: AND PACT.payroll_id = TP.payroll_id
42: AND p_date BETWEEN TP.start_date AND TP.end_date;

Line 93: FROM per_time_periods TP

89:
90: CURSOR cur_end_date ( p_pactid NUMBER
91: ) IS
92: SELECT TP.end_date + 1
93: FROM per_time_periods TP
94: , pay_payroll_actions PACT
95: WHERE PACT.payroll_action_id = p_pactid
96: AND PACT.payroll_id = TP.payroll_id
97: AND PACT.date_earned BETWEEN TP.start_date AND TP.end_date;