APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_TIME_PERIODS

Line 47: FROM per_time_periods ptp

43: l_flag VARCHAR2(1);
44:
45: CURSOR csr_next_pay_proc_end_date(p_start_date DATE) IS
46: SELECT end_date
47: FROM per_time_periods ptp
48: WHERE ptp.payroll_id = p_payroll_id
49: AND ptp.start_date = p_start_date;
50:
51: BEGIN

Line 236: FROM per_time_periods

232: FUNCTION get_fixed_period(p_payroll_id IN NUMBER, p_start_date IN DATE) RETURN NUMBER IS l_fixed_period NUMBER;
233:
234: CURSOR csr_fixed_period IS
235: SELECT period_num
236: FROM per_time_periods
237: WHERE payroll_id = p_payroll_id
238: AND to_char(start_date, 'YYYY') = to_char(p_start_date, 'YYYY')
239: AND prd_information2 = 'Y';
240: BEGIN