APPS.PAY_ADVANCE_PAY_PKG dependencies on PER_TIME_PERIODS

Line 193: from per_time_periods ptp,

189: l_advanced_periods number;
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

Line 230: per_time_periods ptp,

226:
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

Line 280: per_time_periods ptp,

276:
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

Line 330: per_time_periods ptp,

326:
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

Line 333: per_time_periods aptp

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
337: and paf.effective_end_date and

Line 351: per_time_periods ptp,

347: --
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

Line 354: per_time_periods aptp

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
358: and paf.effective_end_date and

Line 418: per_time_periods ptp,

414:
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

Line 421: per_time_periods aptp

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
425: and paf.effective_end_date and

Line 439: per_time_periods ptp,

435: --
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

Line 442: per_time_periods aptp

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
446: and paf.effective_end_date and