APPS.PAY_FI_EXPIRY_SUPPORT dependencies on PER_TIME_PERIODS

Line 63: FROM per_time_periods TP

59: -- result in the expiration of the balance.
60: --
61: SELECT TP.start_date
62: INTO l_period_start_date
63: FROM per_time_periods TP
64: ,pay_payroll_actions PACT
65: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
66: AND PACT.payroll_id = TP.payroll_id
67: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;