APPS.JG_ZZ_COMMON_PKG dependencies on XLE_ETB_PROFILES

Line 344: ,XLE_ETB_PROFILES xetbp

340: BEGIN
341: SELECT zptp.REP_REGISTRATION_NUMBER
342: INTO x_vat_reg_num
343: FROM ZX_PARTY_TAX_PROFILE zptp
344: ,XLE_ETB_PROFILES xetbp
345: WHERE zptp.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'
346: AND xetbp.party_id=zptp.party_id
347: AND xetbp.MAIN_ESTABLISHMENT_FLAG = 'Y'
348: AND xetbp.LEGAL_ENTITY_ID = pn_legal_entity_id;