APPS.AR_MATCH_REV_COGS_GRP dependencies on AR_SYSTEM_PARAMETERS

Line 154: FROM gl_period_statuses ps, ar_system_parameters sp

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

Line 235: ar_system_parameters_all p

231: distinct l.sales_order, l.org_id
232: FROM ra_customer_trx_lines_all l,
233: ra_cust_trx_line_gl_dist_all gld,
234: ra_cust_trx_line_gl_dist_all gld2,
235: ar_system_parameters_all p
236: WHERE gld.gl_date between p_low_date and p_hi_date
237: AND gld2.account_set_flag = 'N'
238: AND gld.org_id = p.org_id
239: AND p.set_of_books_id = p_ledger_id