APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_PARTIES

Line 5810: HZ_PARTIES hzp

5806: b_ptp_id NUMBER
5807: ) IS
5808: SELECT UPPER(REPLACE(hzp.PARTY_NAME,' ','_'))
5809: FROM ZX_PARTY_TAX_PROFILE ptp,
5810: HZ_PARTIES hzp
5811: WHERE ptp.PARTY_TAX_PROFILE_ID = b_ptp_id
5812: AND ptp.PARTY_TYPE_CODE = 'TAX_PARTNER'
5813: AND ptp.PARTY_ID = hzp.PARTY_ID;
5814:

Line 5815: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

5811: WHERE ptp.PARTY_TAX_PROFILE_ID = b_ptp_id
5812: AND ptp.PARTY_TYPE_CODE = 'TAX_PARTNER'
5813: AND ptp.PARTY_ID = hzp.PARTY_ID;
5814:
5815: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5816: l_migrated_tax_regime_flag VARCHAR2(1);
5817: l_tax_content_source VARCHAR2(80);
5818: l_tax_zone_type VARCHAR2(30);
5819: l_last_run_version NUMBER;