DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on XLE_ETB_PROFILES

Line 1720: FROM XLE_ETB_PROFILES xletb,

1716: SELECT pty.party_number,
1717: xletb.name
1718: INTO l_legal_entity_number,
1719: l_establishment_name
1720: FROM XLE_ETB_PROFILES xletb,
1721: XLE_ENTITY_PROFILES xlent,
1722: HZ_PARTIES pty
1723: WHERE xletb.establishment_id = p_event_class_rec.establishment_id
1724: AND xlent.legal_entity_id = xletb.legal_entity_id

Line 1753: FROM XLE_ETB_PROFILES xletb,

1749: END;
1750: BEGIN
1751: SELECT pty.party_number
1752: INTO l_legal_entity_number
1753: FROM XLE_ETB_PROFILES xletb,
1754: HZ_PARTIES pty,
1755: XLE_ENTITY_PROFILES xep
1756: WHERE xletb.party_id = l_party_id
1757: AND xletb.legal_entity_id = xep.legal_entity_id