APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_PAYROLLS_F

Line 229: pay_payrolls_f ppf,

225: cursor period_end_date is
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

Line 279: pay_payrolls_f ppf,

275: cursor period_start_date is
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

Line 329: pay_payrolls_f ppf,

325: cursor period_start_date is
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

Line 350: pay_payrolls_f ppf,

346: cursor r_period_start_date is
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

Line 417: pay_payrolls_f ppf,

413: cursor period_start_date is
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

Line 438: pay_payrolls_f ppf,

434: cursor r_period_start_date is
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