APPS.JG_ZZ_COMMON_PKG dependencies on ZX_PARTY_TAX_PROFILE
Line 354: FROM ZX_PARTY_TAX_PROFILE zptp
350: IF p_vat_reporting_entity_id is null THEN -- NONEMEAVAT REPORT
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'