DBA Data[Home] [Help]

APPS.XTR_HEDGE_PROCESS_P dependencies on GL_LEDGER_LE_V

Line 2124: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle

2120: from ra_batch_sources_all bs,
2121: hr_operating_units ho,
2122: xtr_parties_v xp
2123: where bs.org_id = ho.organization_id
2124: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle
2125: WHERE glle.legal_entity_id = xp.legal_entity_id
2126: AND glle.ledger_category_code = 'PRIMARY') -- bug 4654775
2127: and xp.party_code = nvl(p_company,xp.party_code) --BUG 3002000 #7
2128: and bs.name = p_source;

Line 2136: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle

2132: from ra_cust_trx_types_all tt,
2133: hr_operating_units ho,
2134: xtr_parties_v xp
2135: where tt.org_id = ho.organization_id
2136: and ho.set_of_books_id = (SELECT glle.ledger_id FROM gl_ledger_le_v glle
2137: WHERE glle.legal_entity_id = xp.legal_entity_id
2138: AND glle.ledger_category_code = 'PRIMARY') -- bug 4654775
2139: and xp.party_code = nvl(p_company,xp.party_code) -- BUG 3002000 #7
2140: and tt.name = p_trxtype