APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_OTHER_PERIODS

Line 2235: FROM ap_other_periods

2231: RETURN null;
2232: ELSE
2233: SELECT period_name
2234: INTO l_period_name
2235: FROM ap_other_periods
2236: WHERE application_id = 200
2237: AND module = 'AWT'
2238: AND period_type = P_Period_Type
2239: AND start_date <= trunc(P_AWT_Date)

Line 3036: FROM ap_other_periods

3032: -- Obtains start and end date for a given period
3033: -------------------------------------------------
3034: SELECT start_date, end_date
3035: INTO l_start_date, l_end_date
3036: FROM ap_other_periods
3037: WHERE application_id = 200
3038: AND module = 'AWT'
3039: AND period_type = P_AWT_Period_Type
3040: AND period_name = l_period_name;