APPS.PAY_SG_EXC dependencies on PER_TIME_PERIODS

Line 42: from per_time_periods TP,

38: l_return_val DATE := NULL;
39: BEGIN
40: select TP.end_date + 1
41: into l_return_val
42: from per_time_periods TP,
43: pay_payroll_actions PACT
44: where PACT.payroll_action_id = p_pactid
45: and PACT.payroll_id = TP.payroll_id
46: and p_date between TP.start_date and TP.end_date;