APPS.XTR_FPS2_P dependencies on GL_SETS_OF_BOOKS

Line 219: GL_SETS_OF_BOOKS d

215: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
216: from XTR_PARTIES_V a,
217: XTR_MASTER_CURRENCIES b,
218: HR_LEGAL_ENTITIES c,
219: GL_SETS_OF_BOOKS d
220: where a.PARTY_TYPE = 'C'
221: and a.DEFAULT_COMPANY = 'Y'
222: and c.ORGANIZATION_ID = a.LEGAL_ENTITY_ID
223: and c.SET_OF_BOOKS_ID = d.SET_OF_BOOKS_ID

Line 231: GL_SETS_OF_BOOKS d

227: select d.CURRENCY_CODE, b.NAME
228: from XTR_PARTIES_V a,
229: XTR_MASTER_CURRENCIES b,
230: HR_LEGAL_ENTITIES c,
231: GL_SETS_OF_BOOKS d
232: where a.PARTY_TYPE = 'C'
233: and a.PARTY_CODE = l_comp
234: and c.ORGANIZATION_ID = a.LEGAL_ENTITY_ID
235: and c.SET_OF_BOOKS_ID = d.SET_OF_BOOKS_ID

Line 243: GL_SETS_OF_BOOKS d

239: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
240: from XTR_PARTIES_V a,
241: XTR_MASTER_CURRENCIES b,
242: GL_LEDGER_LE_V c,
243: GL_SETS_OF_BOOKS d
244: where a.PARTY_TYPE = 'C'
245: and a.DEFAULT_COMPANY = 'Y'
246: and c.LEGAL_ENTITY_ID = a.LEGAL_ENTITY_ID
247: and c.LEDGER_ID = d.SET_OF_BOOKS_ID

Line 256: GL_SETS_OF_BOOKS d

252: select d.CURRENCY_CODE, b.NAME
253: from XTR_PARTIES_V a,
254: XTR_MASTER_CURRENCIES b,
255: GL_LEDGER_LE_V c,
256: GL_SETS_OF_BOOKS d
257: where a.PARTY_TYPE = 'C'
258: and a.PARTY_CODE = l_comp
259: and c.LEGAL_ENTITY_ID = a.LEGAL_ENTITY_ID
260: and c.LEDGER_ID = d.SET_OF_BOOKS_ID