APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_OTHER_PERIODS

Line 2190: FROM ap_other_periods

2186: RETURN null;
2187: ELSE
2188: SELECT period_name
2189: INTO l_period_name
2190: FROM ap_other_periods
2191: WHERE application_id = 200
2192: AND module = 'AWT'
2193: AND period_type = P_Period_Type
2194: AND start_date <= trunc(P_AWT_Date)

Line 2994: FROM ap_other_periods

2990: -- Obtains start and end date for a given period
2991: -------------------------------------------------
2992: SELECT start_date, end_date
2993: INTO l_start_date, l_end_date
2994: FROM ap_other_periods
2995: WHERE application_id = 200
2996: AND module = 'AWT'
2997: AND period_type = P_AWT_Period_Type
2998: AND period_name = l_period_name;