DBA Data[Home] [Help]

APPS.PAY_ZA_UPDATE_PKG dependencies on PER_TIME_PERIODS

Line 51: per_time_periods ptp

47:
48: Select
49: ptp.prd_information1 into l_tax_year
50: From
51: per_time_periods ptp
52: Where
53: ptp.payroll_id = p_payroll
54: And (sysdate - 365) between ptp.start_date and ptp.end_date;
55:

Line 80: per_time_periods ptp

76: l_year := TO_CHAR(TO_NUMBER( SUBSTR(p_tax_year,-4) ) - 1);
77:
78: SELECT MAX(ptp.end_date) + 1 INTO l_tax_year_end
79: FROM
80: per_time_periods ptp
81: WHERE
82: ptp.payroll_id = p_payroll
83: AND ptp.prd_information1 = SUBSTR(p_tax_year,-4);
84: