APPS.AR_INVOICE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 2587: gl_sets_of_books b

2583: BEGIN
2584: SELECT closing_status
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

Line 5582: gl_sets_of_books gsob

5578: from hr_organization_units hou,
5579: hr_organization_information hoi1,
5580: hr_organization_information hoi2,
5581: mtl_parameters mp,
5582: gl_sets_of_books gsob
5583: where hou.organization_id = hoi1.organization_id
5584: and hou.organization_id = hoi2.organization_id
5585: and hou.organization_id = mp.organization_id
5586: and hoi1.org_information1 = 'INV'

Line 5736: gl_sets_of_books gl

5732: (SELECT COUNT(*)
5733: FROM ar_periods gps,
5734: ra_rules rr2,
5735: ar_system_parameters sys,
5736: gl_sets_of_books gl
5737: WHERE
5738: rr2.rule_id = a.ACCOUNTING_RULE_ID
5739: AND rr2.frequency = gps.period_type
5740: AND rr2.type NOT IN ('A', 'ACC_DUR')

Line 5838: gl_sets_of_books sob,

5834: and also added check for the status of the gl_period with a join to gl_period_statuses */
5835: SELECT COUNT(*)
5836: INTO l_period_exist
5837: FROM gl_periods gp,
5838: gl_sets_of_books sob,
5839: gl_period_statuses gps
5840: WHERE sob.set_of_books_id = l_set_of_books_id
5841: AND gp.adjustment_period_flag = 'N'
5842: AND gp.period_set_name = sob.period_set_name

Line 7526: GL_SETS_OF_BOOKS G,

7522: FROM ar_trx_DIST_gt D,
7523: ar_trx_header_gt h
7524: --RA_CUST_TRX_TYPES TYPE,
7525: FND_CURRENCIES C,
7526: GL_SETS_OF_BOOKS G,
7527: --RA_CUSTOMER_TRX PREV_TRX,
7528: ar_trx_LINES_GT L_PARENT,
7529: ar_trx_LINES_GT L
7530: WHERE --L.REQUEST_ID = :request_id