DBA Data[Home] [Help]

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'