DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on PER_TIME_PERIODS

Line 27: FROM per_time_periods ptp

23: --
24: CURSOR get_period_dates IS
25: SELECT ptp.start_date start_date
26: ,ptp.end_date end_date
27: FROM per_time_periods ptp
28: WHERE ptp.payroll_id=p_payroll_id
29: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
30: --
31: -- Cursor get_db

Line 95: FROM per_time_periods ptp

91: --
92: CURSOR get_period_dates IS
93: SELECT ptp.start_date start_date
94: ,ptp.end_date end_date
95: FROM per_time_periods ptp
96: WHERE ptp.payroll_id=p_payroll_id
97: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
98: --
99: -- Cursor get_db