DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on XLE_ETB_PROFILES

Line 60: xle_etb_profiles xle_etb,

56: BEGIN
57: SELECT xle_etb.establishment_id
58: INTO l_estb_id
59: FROM zx_party_tax_profile ptp,
60: xle_etb_profiles xle_etb,
61: ap_invoices_all ai
62: WHERE ai.invoice_id = p_upg_trx_info_rec.trx_id
63: AND ptp.party_id = xle_etb.party_id
64: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'