APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on GL_PERIOD_STATUSES

Line 225: FROM gl_period_statuses gps,

221: -- Obtains the name of the period
222: ----------------------------------
223: SELECT gps.period_name
224: INTO l_gl_period_name
225: FROM gl_period_statuses gps,
226: ap_system_parameters asp
227: WHERE gps.application_id = 200
228: AND gps.set_of_books_id = asp.set_of_books_id
229: AND trunc(P_AWT_Date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date) --bug9869654