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 2589: AND g.set_of_books_id = arp_global.set_of_books_id

2585: INTO l_period_status
2586: FROM gl_period_statuses g,
2587: gl_sets_of_books b
2588: WHERE b.set_of_books_id = g.set_of_books_id
2589: AND g.set_of_books_id = arp_global.set_of_books_id
2590: AND g.period_type = b.accounted_period_type
2591: AND g.application_id = 222
2592: AND g.adjustment_period_flag = 'N'
2593: AND closing_status <> 'C'

Line 5918: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id

5914: AND NOT EXISTS
5915: (SELECT 'X'
5916: FROM gl_ussgl_transaction_codes gutc
5917: WHERE gutc.ussgl_transaction_code = gt.default_ussgl_transaction_code
5918: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id
5919: AND gt.trx_date
5920: BETWEEN NVL(gutc.start_date_active, gt.trx_date)
5921: AND NVL(gutc.end_date_active, gt.trx_date));
5922:

Line 7050: structure_number => ARP_GLOBAL.chart_of_accounts_id,

7046: LOOP
7047: IF NOT fnd_flex_keyval.validate_ccid (
7048: appl_short_name => 'SQLGL',
7049: key_flex_code => 'GL#',
7050: structure_number => ARP_GLOBAL.chart_of_accounts_id,
7051: combination_id => CccidRec.code_combination_id )
7052: THEN
7053: INSERT INTO ar_trx_errors_gt
7054: ( trx_header_id,