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_ADVANCE_PAY_PKG dependencies on PER_ASSIGNMENTS_F

Line 194: per_assignments_f paf

190:
191: cursor advanced_periods is
192: select count(ptp.time_period_id)
193: from per_time_periods ptp,
194: per_assignments_f paf
195: where paf.assignment_id = p_assignment_id and
196: p_advance_pay_start_date between paf.effective_start_date
197: and paf.effective_end_date and
198: ptp.payroll_id = paf.payroll_id and

Line 232: per_assignments_f paf

228: select ptp.end_date
229: from
230: per_time_periods ptp,
231: pay_payrolls_f ppf,
232: per_assignments_f paf
233: where
234: paf.assignment_id = p_assignment_id and
235: p_session_date between paf.effective_start_date
236: and paf.effective_end_date and

Line 282: per_assignments_f paf

278: select ptp.start_date
279: from
280: per_time_periods ptp,
281: pay_payrolls_f ppf,
282: per_assignments_f paf
283: where
284: paf.assignment_id = p_assignment_id and
285: p_session_date between paf.effective_start_date
286: and paf.effective_end_date and

Line 332: per_assignments_f paf,

328: select aptp.start_date
329: from
330: per_time_periods ptp,
331: pay_payrolls_f ppf,
332: per_assignments_f paf,
333: per_time_periods aptp
334: where
335: paf.assignment_id = p_assignment_id and
336: p_session_date between paf.effective_start_date

Line 353: per_assignments_f paf,

349: select aptp.start_date
350: from
351: per_time_periods ptp,
352: pay_payrolls_f ppf,
353: per_assignments_f paf,
354: per_time_periods aptp
355: where
356: paf.assignment_id = p_assignment_id and
357: p_session_date between paf.effective_start_date

Line 420: per_assignments_f paf,

416: select aptp.end_date
417: from
418: per_time_periods ptp,
419: pay_payrolls_f ppf,
420: per_assignments_f paf,
421: per_time_periods aptp
422: where
423: paf.assignment_id = p_assignment_id and
424: p_session_date between paf.effective_start_date

Line 441: per_assignments_f paf,

437: select aptp.end_date
438: from
439: per_time_periods ptp,
440: pay_payrolls_f ppf,
441: per_assignments_f paf,
442: per_time_periods aptp
443: where
444: paf.assignment_id = p_assignment_id and
445: p_session_date between paf.effective_start_date