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 192: per_assignments_f paf

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

Line 230: per_assignments_f paf

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

Line 280: per_assignments_f paf

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

Line 330: per_assignments_f paf,

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

Line 351: per_assignments_f paf,

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

Line 418: per_assignments_f paf,

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

Line 439: per_assignments_f paf,

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