DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on XLE_ETB_PROFILES

Line 55: xle_etb_profiles xle_etb,

51: BEGIN
52: SELECT xle_etb.establishment_id
53: INTO l_estb_id
54: FROM zx_party_tax_profile ptp,
55: xle_etb_profiles xle_etb,
56: ra_customer_trx_all custtrx
57: WHERE custtrx.customer_trx_id = p_upg_trx_info_rec.trx_id
58: AND ptp.party_id = xle_etb.party_id
59: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'