APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_PAYROLLS_F

Line 231: pay_payrolls_f ppf,

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

Line 281: pay_payrolls_f ppf,

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

Line 331: pay_payrolls_f ppf,

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

Line 352: pay_payrolls_f ppf,

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

Line 419: pay_payrolls_f ppf,

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

Line 440: pay_payrolls_f ppf,

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