APPS.PQP_EXPREPLOD_PKG dependencies on PER_TIME_PERIODS

Line 307: FROM per_time_periods ptp

303: CURSOR c_maxdate
304: IS
305: SELECT MAX(greatest(ptp.end_date,ptp.regular_payment_date)) pay_date,
306: MAX (ptp.end_date)
307: FROM per_time_periods ptp
308: WHERE ptp.payroll_id=p_payroll_id
309: AND ptp.end_date <= p_effective_date;
310:
311: CURSOR c_prev_per(maxdate DATE)

Line 314: FROM per_time_periods ptp

310:
311: CURSOR c_prev_per(maxdate DATE)
312: IS
313: SELECT MAX(greatest(ptp.end_date,ptp.regular_payment_date)) prev_pay_period
314: FROM per_time_periods ptp
315: WHERE ptp.payroll_id =p_payroll_id
316: AND ptp.end_date < maxdate;
317:
318: CURSOR c_avg_per_days(maxdate DATE,no_days NUMBER)

Line 321: FROM per_time_periods ptp

317:
318: CURSOR c_avg_per_days(maxdate DATE,no_days NUMBER)
319: IS
320: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
321: FROM per_time_periods ptp
322: WHERE ptp.payroll_id =p_payroll_id
323: AND ptp.end_date >= maxdate-no_days
324: AND ptp.end_date < maxdate
325: ORDER BY end_date desc;

Line 330: FROM per_time_periods ptp

326:
327: CURSOR c_avg_per (maxdate DATE,no_period NUMBER)
328: IS
329: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
330: FROM per_time_periods ptp
331: WHERE ptp.payroll_id = p_payroll_id
332: AND no_period >=(Select count(*)
333: FROM per_time_periods ptp1
334: WHERE ptp1.payroll_id =p_payroll_id

Line 333: FROM per_time_periods ptp1

329: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
330: FROM per_time_periods ptp
331: WHERE ptp.payroll_id = p_payroll_id
332: AND no_period >=(Select count(*)
333: FROM per_time_periods ptp1
334: WHERE ptp1.payroll_id =p_payroll_id
335: AND ptp1.end_date < maxdate
336: AND ptp.end_date <=ptp1.end_date)
337: AND ptp.end_date < maxdate

Line 886: FROM per_time_periods ptp

882: IS
883: SELECT MAX(pay_date)maxdate,
884: MIN(pay_st_date) mindate
885: FROM (SELECT MAX(ptp.start_date) pay_st_date,MAX(ptp.end_date) pay_date
886: FROM per_time_periods ptp
887: WHERE ptp.payroll_id IN (SELECT payroll_id
888: FROM pay_payroll_actions ppa
889: WHERE ppa.consolidation_set_id=p_consolidation_set_id
890: AND (payroll_id =p_payroll_id

Line 995: FROM per_time_periods ptp

991: ) IS
992: CURSOR c_filterasg (p_payroll_id NUMBER)
993: IS
994: SELECT MAX(ptp.start_date),MAX(ptp.end_date) pay_date
995: FROM per_time_periods ptp
996: WHERE ptp.payroll_id=p_payroll_id
997: AND ptp.end_date <= p_effective_date;
998:
999: CURSOR sel_aaid (l_pactid number