DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on XLE_ETB_PROFILES

Line 1881: FROM XLE_ETB_PROFILES xletb,

1877: SELECT pty.party_number,
1878: xletb.name
1879: INTO l_legal_entity_number,
1880: l_establishment_name
1881: FROM XLE_ETB_PROFILES xletb,
1882: XLE_ENTITY_PROFILES xlent,
1883: HZ_PARTIES pty
1884: WHERE xletb.establishment_id = p_event_class_rec.establishment_id
1885: AND xlent.legal_entity_id = xletb.legal_entity_id

Line 1914: FROM XLE_ETB_PROFILES xletb,

1910: END;
1911: BEGIN
1912: SELECT pty.party_number
1913: INTO l_legal_entity_number
1914: FROM XLE_ETB_PROFILES xletb,
1915: HZ_PARTIES pty,
1916: XLE_ENTITY_PROFILES xep
1917: WHERE xletb.party_id = l_party_id
1918: AND xletb.legal_entity_id = xep.legal_entity_id