APPS.AR_MATCH_REV_COGS_GRP dependencies on GL_PERIOD_STATUSES

Line 72: FROM gl_period_statuses ps

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

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

588: tl.set_of_books_id
589: FROM ra_customer_trx_lines_all tl,
590: ra_customer_trx_lines_all tli,
591: ra_cust_trx_line_gl_dist_all tlgld,
592: gl_period_statuses gps
593: WHERE
594: tl.sales_order = so_numbers(i)
595: AND tl.org_id = so_orgs(i)
596: AND tl.customer_trx_line_id = tlgld.customer_trx_line_id

Line 739: gl_period_statuses gps

735: rev_percent,
736: max(rev.org_id) org_id,
737: gps.set_of_books_id set_of_books_id
738: FROM ar_trx_cogs_gt rev,
739: gl_period_statuses gps
740: WHERE gps.application_id = 222
741: AND gps.set_of_books_id = rev.set_of_books_id
742: AND gps.ledger_id = p_ledger_id
743: AND gps.start_date <= p_to_gl_date