APPS.PAY_IE_NES_REPORT_PKG dependencies on PER_TIME_PERIODS

Line 1351: , per_time_periods ptp

1347: select ptp.period_type period_type,
1348: count(ptp.period_num) pay_periods
1349: from
1350: pay_payroll_actions ppa
1351: , per_time_periods ptp
1352: , per_time_period_types tptype
1353: WHERE ppa.payroll_action_id=c_payroll_action_id
1354: AND ptp.payroll_id=ppa.payroll_id
1355: AND ptp.period_type = tptype.period_type

Line 1523: l_period_type per_time_periods.period_type%type;

1519: l_other_absence NUMBER;
1520: l_gross_earning NUMBER:=0; /* 9795571 */
1521: l_prsi_class VARCHAR2(10);
1522: l_prsi_subclass VARCHAR2(10);
1523: l_period_type per_time_periods.period_type%type;
1524: l_pay_periods number;
1525: l_freq_pay NUMBER;
1526: l_employement_type NUMBER:=1; /* 9795685 */
1527: l_ref_period_pay NUMBER;