APPS.PQP_EXPREPLOD_PKG dependencies on PER_TIME_PERIODS

Line 464: FROM per_time_periods ptp

460: CURSOR c_maxdate
461: IS
462: SELECT MAX(greatest(ptp.end_date,ptp.regular_payment_date)) pay_date,
463: MAX (ptp.end_date)
464: FROM per_time_periods ptp
465: WHERE ptp.payroll_id=p_payroll_id
466: AND ptp.end_date <= p_effective_date;
467:
468: CURSOR c_prev_per(maxdate DATE)

Line 471: FROM per_time_periods ptp

467:
468: CURSOR c_prev_per(maxdate DATE)
469: IS
470: SELECT MAX(greatest(ptp.end_date,ptp.regular_payment_date)) prev_pay_period
471: FROM per_time_periods ptp
472: WHERE ptp.payroll_id =p_payroll_id
473: AND ptp.end_date < maxdate;
474:
475: CURSOR c_avg_per_days(maxdate DATE,no_days NUMBER)

Line 478: FROM per_time_periods ptp

474:
475: CURSOR c_avg_per_days(maxdate DATE,no_days NUMBER)
476: IS
477: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
478: FROM per_time_periods ptp
479: WHERE ptp.payroll_id =p_payroll_id
480: AND ptp.end_date >= maxdate-no_days
481: AND ptp.end_date < maxdate
482: ORDER BY end_date desc;

Line 487: FROM per_time_periods ptp

483:
484: CURSOR c_avg_per (maxdate DATE,no_period NUMBER)
485: IS
486: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
487: FROM per_time_periods ptp
488: WHERE ptp.payroll_id = p_payroll_id
489: AND no_period >=(Select count(*)
490: FROM per_time_periods ptp1
491: WHERE ptp1.payroll_id =p_payroll_id

Line 490: FROM per_time_periods ptp1

486: SELECT greatest(ptp.end_date,ptp.regular_payment_date) pay_date
487: FROM per_time_periods ptp
488: WHERE ptp.payroll_id = p_payroll_id
489: AND no_period >=(Select count(*)
490: FROM per_time_periods ptp1
491: WHERE ptp1.payroll_id =p_payroll_id
492: AND ptp1.end_date < maxdate
493: AND ptp.end_date <=ptp1.end_date)
494: AND ptp.end_date < maxdate

Line 1064: FROM per_time_periods ptp

1060: IS
1061: SELECT MAX(pay_date)maxdate,
1062: MIN(pay_st_date) mindate
1063: FROM (SELECT MAX(ptp.start_date) pay_st_date,MAX(ptp.end_date) pay_date
1064: FROM per_time_periods ptp
1065: WHERE ptp.payroll_id IN (SELECT payroll_id
1066: FROM pay_payroll_actions ppa
1067: WHERE ppa.consolidation_set_id=p_consolidation_set_id
1068: AND (payroll_id =p_payroll_id

Line 1173: FROM per_time_periods ptp

1169: ) IS
1170: CURSOR c_filterasg (p_payroll_id NUMBER)
1171: IS
1172: SELECT MAX(ptp.start_date),MAX(ptp.end_date) pay_date
1173: FROM per_time_periods ptp
1174: WHERE ptp.payroll_id=p_payroll_id
1175: AND ptp.end_date <= p_effective_date;
1176:
1177: CURSOR sel_aaid (l_pactid number