APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_PARTIES_V

Line 772: from xtr_parties_v

768: where deal_no = p_deal_no;
769:
770: cursor sob_ccy is
771: select set_of_books_currency
772: from xtr_parties_v
773: where party_code = p_company
774: and party_type = 'C';
775:
776: Begin

Line 2122: xtr_parties_v xp

2118: Cursor ar_source(p_source in VARCHAR2, p_company in VARCHAR2) is
2119: select '(BATCH_SOURCE_ID = '|| batch_source_id || ' AND ORG_ID = '||org_id||') OR ' source
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

Line 2134: xtr_parties_v xp

2130: Cursor ar_trxtype(p_trxtype in VARCHAR2, p_company in VARCHAR2) is
2131: select '(CUST_TRX_TYPE_ID = '|| cust_trx_type_id || ' AND ORG_ID = '||org_id||') OR ' trxtype
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