APPS.JG_TAXID_VAL_PKG dependencies on HZ_CUST_ACCOUNTS

Line 91: FROM hz_parties hzp, hz_cust_accounts hzc

87: ) RETURN VARCHAR2 IS
88:
89: CURSOR CHECK_UNIQUE_TAXID_AR IS -- Customers for Argentina, Chile, and Colombia
90: SELECT hzp.JGZZ_FISCAL_CODE
91: FROM hz_parties hzp, hz_cust_accounts hzc
92: WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
93: AND hzc.party_id = hzp.party_id
94: AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0)
95: AND substrb(nvl(HZC.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;

Line 99: FROM hz_parties hzp, hz_cust_accounts hzc

95: AND substrb(nvl(HZC.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
96:
97: CURSOR CHECK_UNIQUE_TAXID_AR_TW IS -- Customers for Taiwan
98: SELECT hzp.JGZZ_FISCAL_CODE
99: FROM hz_parties hzp, hz_cust_accounts hzc
100: WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
101: AND hzc.party_id = hzp.party_id
102: AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0);
103:

Line 137: FROM hz_parties hzp, hz_cust_accounts hzc

133: -- Removed cursor to check on ap_bank_branches
134:
135: CURSOR CHECK_UNIQUE_TAXID_AR1 IS -- CUSTOMERS
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

Line 383: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC

379:
380: CURSOR CHECK_CROSS_AR IS --Customers
381: SELECT HZP.PARTY_NAME, HZP.JGZZ_FISCAL_CODE,
382: HZC.GLOBAL_ATTRIBUTE9, HZC.GLOBAL_ATTRIBUTE10
383: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC
384: WHERE (HZP.PARTY_NAME=p_entity_name
385: OR HZP.JGZZ_FISCAL_CODE=p_taxpayer_id)
386: AND substrb(nvl(HZC.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2)=p_country_code
387: AND HZP.PARTY_ID = HZC.PARTY_ID;