APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PER_TIME_PERIODS

Line 27: FROM per_time_periods ptp

23: CURSOR c_payroll_details(p_period number) IS
24: SELECT start_date,
25: end_date,
26: regular_payment_date
27: FROM per_time_periods ptp
28: WHERE ptp.time_period_id = p_period;
29:
30: CURSOR c_prp_details(p_payroll number) IS
31: SELECT start_date,

Line 34: FROM per_time_periods ptp

30: CURSOR c_prp_details(p_payroll number) IS
31: SELECT start_date,
32: end_date,
33: regular_payment_date
34: FROM per_time_periods ptp
35: WHERE trunc(l_pay_date_paid) BETWEEN start_date AND end_date
36: AND payroll_id=p_payroll;
37:
38: CURSOR c_comm_details(P_PAYROLL_ID number)