DBA Data[Home] [Help]

APPS.HRWSDPR dependencies on PER_TIME_PERIODS

Line 11: from per_time_periods ptp

7: p_end_date IN OUT date,
8: p_session_date date) is
9: cursor c is
10: select period_name, start_date, end_date
11: from per_time_periods ptp
12: where p_payroll_id = ptp.payroll_id
13: and p_given_date between ptp.start_date and ptp.end_date
14: and ptp.start_date <= p_session_date;
15: begin