APPS.AR_INVOICE_UTILS dependencies on ARP_GLOBAL

Line 246: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id

242: AND NOT EXISTS
243: (SELECT 'X'
244: FROM gl_ussgl_transaction_codes gutc
245: WHERE gutc.ussgl_transaction_code = gt.default_ussgl_transaction_code
246: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id
247: AND gt.trx_date
248: BETWEEN NVL(gutc.start_date_active, gt.trx_date)
249: AND NVL(gutc.end_date_active, gt.trx_date));
250:

Line 2512: AND g.set_of_books_id = arp_global.set_of_books_id

2508: INTO l_period_status
2509: FROM gl_period_statuses g,
2510: gl_sets_of_books b
2511: WHERE b.set_of_books_id = g.set_of_books_id
2512: AND g.set_of_books_id = arp_global.set_of_books_id
2513: AND g.period_type = b.accounted_period_type
2514: AND g.application_id = 222
2515: AND g.adjustment_period_flag = 'N'
2516: AND closing_status <> 'C'

Line 5791: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id

5787: AND NOT EXISTS
5788: (SELECT 'X'
5789: FROM gl_ussgl_transaction_codes gutc
5790: WHERE gutc.ussgl_transaction_code = gt.default_ussgl_transaction_code
5791: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id
5792: AND gt.trx_date
5793: BETWEEN NVL(gutc.start_date_active, gt.trx_date)
5794: AND NVL(gutc.end_date_active, gt.trx_date));
5795:

Line 6726: structure_number => ARP_GLOBAL.chart_of_accounts_id,

6722: LOOP
6723: IF NOT fnd_flex_keyval.validate_ccid (
6724: appl_short_name => 'SQLGL',
6725: key_flex_code => 'GL#',
6726: structure_number => ARP_GLOBAL.chart_of_accounts_id,
6727: combination_id => CccidRec.code_combination_id )
6728: THEN
6729: INSERT INTO ar_trx_errors_gt
6730: ( trx_header_id,