APPS.AR_INVOICE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 2510: gl_sets_of_books b

2506: BEGIN
2507: SELECT closing_status
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

Line 5454: gl_sets_of_books gsob

5450: from hr_organization_units hou,
5451: hr_organization_information hoi1,
5452: hr_organization_information hoi2,
5453: mtl_parameters mp,
5454: gl_sets_of_books gsob
5455: where hou.organization_id = hoi1.organization_id
5456: and hou.organization_id = hoi2.organization_id
5457: and hou.organization_id = mp.organization_id
5458: and hoi1.org_information1 = 'INV'

Line 5608: gl_sets_of_books gl

5604: (SELECT COUNT(*)
5605: FROM ar_periods gps,
5606: ra_rules rr2,
5607: ar_system_parameters sys,
5608: gl_sets_of_books gl
5609: WHERE
5610: rr2.rule_id = a.ACCOUNTING_RULE_ID
5611: AND rr2.frequency = gps.period_type
5612: AND rr2.type NOT IN ('A', 'ACC_DUR')

Line 5710: gl_sets_of_books sob,

5706: and also added check for the status of the gl_period with a join to gl_period_statuses */
5707: SELECT COUNT(*)
5708: INTO l_period_exist
5709: FROM gl_periods gp,
5710: gl_sets_of_books sob,
5711: gl_period_statuses gps
5712: WHERE sob.set_of_books_id = l_set_of_books_id
5713: AND gp.adjustment_period_flag = 'N'
5714: AND gp.period_set_name = sob.period_set_name

Line 7187: GL_SETS_OF_BOOKS G,

7183: FROM ar_trx_DIST_gt D,
7184: ar_trx_header_gt h
7185: --RA_CUST_TRX_TYPES TYPE,
7186: FND_CURRENCIES C,
7187: GL_SETS_OF_BOOKS G,
7188: --RA_CUSTOMER_TRX PREV_TRX,
7189: ar_trx_LINES_GT L_PARENT,
7190: ar_trx_LINES_GT L
7191: WHERE --L.REQUEST_ID = :request_id