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

Line 217: ,per_time_periods ptp

213: select
214: min(asg.effective_start_date) start_date
215: from
216: per_all_assignments_f asg
217: ,per_time_periods ptp
218: where
219: asg.assignment_id = p_assignment_id
220: and ptp.payroll_id = asg.payroll_id
221: and asg.effective_start_date between ptp.start_date

Line 234: ,per_time_periods ptp

230: select
231: min(ptp.start_date) start_date
232: from
233: per_all_assignments_f asg
234: ,per_time_periods ptp
235: where
236: asg.assignment_id = p_assignment_id
237: and ptp.payroll_id = asg.payroll_id
238: and ptp.start_date between asg.effective_start_date

Line 332: ,per_time_periods ptp

328: ,p_expiry_date DATE) IS
329: SELECT nvl(GREATEST(MIN(ass.effective_start_date), MIN(ptp.start_date), p_expiry_date)
330: ,END_OF_TIME)
331: FROM per_assignments_f ass
332: ,per_time_periods ptp
333: WHERE ass.assignment_id = p_assignment_id
334: AND ass.effective_start_date <= p_upload_date
335: AND ass.effective_end_date >= p_expiry_date
336: AND ptp.payroll_id = ass.payroll_id

Line 349: ,per_time_periods ptp

345: ,p_upload_date DATE
346: ) IS
347: SELECT ptp.start_date
348: FROM per_all_assignments_f ass
349: ,per_time_periods ptp
350: WHERE ass.assignment_id = p_assignment_id
351: AND ass.effective_start_date <= p_upload_date
352: AND ass.effective_end_date >= p_upload_date
353: AND ptp.payroll_id = ass.payroll_id