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

Line 98: per_time_periods ptp,per_time_periods ptp2,per_assignments_f ass

94: ) is
95: select
96: nvl(min(ptp2.start_date), END_OF_TIME)
97: from
98: per_time_periods ptp,per_time_periods ptp2,per_assignments_f ass
99: where
100: ass.assignment_id = p_assignment_id
101: and
102: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 122: per_time_periods ptp, per_assignments_f ass

118: ) is
119: select
120: nvl(ptp.start_date, END_OF_TIME)
121: from
122: per_time_periods ptp, per_assignments_f ass
123: where
124: ass.assignment_id = p_assignment_id
125: and
126: ptp.payroll_id = ass.payroll_id

Line 161: per_time_periods ptp, per_assignments_f ass

157: ) is
158: select
159: min(ptp.regular_payment_date)
160: from
161: per_time_periods ptp, per_assignments_f ass
162: where
163: ass.assignment_id = l_assignment_id
164: and
165: ptp.payroll_id = ass.payroll_id

Line 182: per_time_periods ptp, per_assignments_f ass

178: ) is
179: select
180: ptp.regular_payment_date
181: from
182: per_time_periods ptp, per_assignments_f ass
183: where
184: ass.assignment_id = l_assignment_id
185: and
186: ptp.payroll_id = ass.payroll_id