APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_TIME_PERIODS

Line 46: FROM per_time_periods ptp

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

Line 235: FROM per_time_periods

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