APPS.JG_ZZ_COMMON_PKG dependencies on XLE_ETB_PROFILES
Line 355: ,XLE_ETB_PROFILES xetbp
351: BEGIN
352: SELECT zptp.REP_REGISTRATION_NUMBER
353: INTO x_vat_reg_num
354: FROM ZX_PARTY_TAX_PROFILE zptp 355: ,XLE_ETB_PROFILES xetbp 356: WHERE zptp.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'
357: AND xetbp.party_id=zptp.party_id
358: AND xetbp.MAIN_ESTABLISHMENT_FLAG = 'Y'
359: AND xetbp.LEGAL_ENTITY_ID = pn_legal_entity_id