APPS.AR_MATCH_REV_COGS_GRP dependencies on AR_SYSTEM_PARAMETERS

Line 157: FROM gl_period_statuses ps, ar_system_parameters sp

153: l_msg_data VARCHAR2(150);
154:
155: CURSOR epm IS
156: SELECT effective_period_num, sp.set_of_books_id
157: FROM gl_period_statuses ps, ar_system_parameters sp
158: WHERE ps.set_of_books_id = sp.set_of_books_id
159: AND adjustment_period_flag = 'N'
160: AND application_id = 222
161: AND period_name = p_period_name;

Line 309: FROM ar_system_parameters_all

305: /* 8334354 - changed from sob to org/sob */
306: /* 10029320 - org_id 0 is legit.. and not seeded. */
307: CURSOR ar_operations(p_sob_id NUMBER) IS
308: SELECT org_id, set_of_books_id
309: FROM ar_system_parameters_all
310: WHERE set_of_books_id = NVL(p_sob_id, set_of_books_id)
311: AND set_of_books_id > 0
312: AND org_id >= 0;
313: