[Home] [Help]
136: SELECT hzp.JGZZ_FISCAL_CODE
137: FROM hz_parties hzp, hz_cust_accounts hzc
138: WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
139: AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0)
140: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
141: -- Modified for Countries w/o GDF
142: UNION
143: SELECT I.JGZZ_FISCAL_CODE -- RA_CUSTOMERS_INTERFACE
144: FROM RA_CUSTOMERS_INTERFACE I
144: FROM RA_CUSTOMERS_INTERFACE I
145: WHERE ( I.CUSTOMER_NAME <> p_entity_name
146: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
147: AND I.JGZZ_FISCAL_CODE = p_taxpayer_id
148: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
149: -- Modified for Countries w/o GDF
150: AND I.REQUEST_ID = p_request_id
151: AND NVL(I.VALIDATED_FLAG,'N') <> 'Y'
152: AND ROWNUM = 1;
236: SELECT AR.TAX_REFERENCE
237: FROM RA_CUSTOMERS AR
238: WHERE AR.TAX_REFERENCE = p_tax_reg_num
239: AND AR.CUSTOMER_ID <> nvl(p_record_id,0)
240: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
241: UNION
242:
243: SELECT I.CUST_TAX_REFERENCE -- RA_CUSTOMERS_INTERFACE
244: FROM RA_CUSTOMERS_INTERFACE I
244: FROM RA_CUSTOMERS_INTERFACE I
245: WHERE ( I.CUSTOMER_NAME <> p_entity_name
246: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
247: AND I.CUST_TAX_REFERENCE = p_tax_reg_num
248: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
249: AND I.REQUEST_ID = p_request_id
250: AND NVL(I.VALIDATED_FLAG,'N') <> 'Y'
251: AND ROWNUM = 1;
252: