APPS.AR_MATCH_REV_COGS_GRP dependencies on GL_PERIOD_STATUSES

Line 69: FROM gl_period_statuses ps

65: l_api_name CONSTANT VARCHAR2(30) := 'period_status';
66:
67: CURSOR status IS
68: SELECT closing_status
69: FROM gl_period_statuses ps
70: WHERE adjustment_period_flag = 'N'
71: AND application_id = 222
72: AND set_of_books_id = p_sob_id
73: AND effective_period_num = p_eff_period_num;

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 365: gl_period_statuses gps

361: tl.set_of_books_id
362: FROM ra_customer_trx_lines_all tl,
363: ra_customer_trx_lines_all tli,
364: ra_cust_trx_line_gl_dist_all tlgld,
365: gl_period_statuses gps
366: WHERE
367: tl.sales_order = so_numbers(i)
368: AND tl.org_id = so_orgs(i)
369: AND tl.customer_trx_line_id = tlgld.customer_trx_line_id

Line 455: gl_period_statuses gps

451: rev_percent,
452: max(rev.org_id) org_id,
453: gps.set_of_books_id set_of_books_id
454: FROM ar_trx_cogs_gt rev,
455: gl_period_statuses gps
456: WHERE gps.application_id = 222
457: AND gps.set_of_books_id = rev.set_of_books_id
458: AND gps.start_date <= p_to_gl_date
459: AND gps.adjustment_period_flag = 'N'