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: