DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 343: FROM ZX_PARTY_TAX_PROFILE zptp

339: IF p_vat_reporting_entity_id is null THEN -- NONEMEAVAT REPORT
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'