DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on GL_PERIOD_SETS

Line 180: FROM GL_PERIODS a, gl_period_sets b

176: cursor c_get_period_year(cp_calendar_id number,
177: cp_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE)
178: is
179: SELECT a.PERIOD_YEAR
180: FROM GL_PERIODS a, gl_period_sets b
181: WHERE a.PERIOD_SET_NAME = b.period_set_name
182: and b.period_set_id = cp_calendar_id
183: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;
184: