APPS.ZX_TRN_VALIDATION_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 105: zx_party_tax_profile ptp

101: CURSOR tax_reg_num_csr(c_registration_number varchar2, c_party_type_code varchar2, c_tax_regime_code varchar2, c_tax varchar2, c_tax_jurisdiction_code varchar2) IS
102:
103: SELECT distinct ptp.party_id
104: FROM zx_registrations reg,
105: zx_party_tax_profile ptp
106: WHERE ptp.party_tax_profile_id = reg.party_tax_profile_id
107: AND reg.registration_number = c_registration_number
108: AND sysdate >= reg.effective_from
109: AND (sysdate <= reg.effective_to OR reg.effective_to IS NULL)

Line 134: FROM zx_party_tax_profile

130:
131: CURSOR ptp_type_csr(c_ptp_id number) IS
132:
133: SELECT distinct party_type_code
134: FROM zx_party_tax_profile
135: WHERE party_tax_profile_id = c_ptp_id;
136:
137:
138: CURSOR c_AllowDupRegnNum IS

Line 150: from zx_party_tax_profile s,

146: CURSOR c_third_party_reg_num (c_ptp_id number, c_tax_reg_num varchar2) IS
147: select registration_number
148: from zx_registrations
149: where party_tax_profile_id = (select s.party_tax_profile_id
150: from zx_party_tax_profile s,
151: zx_party_tax_profile ptp,
152: hz_party_sites hzps
153: where ptp.party_tax_profile_id = c_ptp_id
154: and ptp.party_id = hzps.party_site_id

Line 151: zx_party_tax_profile ptp,

147: select registration_number
148: from zx_registrations
149: where party_tax_profile_id = (select s.party_tax_profile_id
150: from zx_party_tax_profile s,
151: zx_party_tax_profile ptp,
152: hz_party_sites hzps
153: where ptp.party_tax_profile_id = c_ptp_id
154: and ptp.party_id = hzps.party_site_id
155: and hzps.party_id = s.party_id

Line 166: zx_party_tax_profile ptp,

162: from zx_registrations regt
163: where regt.party_tax_profile_id = (select ptpp.party_tax_profile_id
164: from xle_fp_establishment_v est,
165: xle_fp_establishment_v estp,
166: zx_party_tax_profile ptp,
167: zx_party_tax_profile ptpp
168: where estp.party_id = ptpp.party_id
169: and estp.legal_entity_id = est.legal_entity_id
170: and est.party_id = ptp.party_id

Line 167: zx_party_tax_profile ptpp

163: where regt.party_tax_profile_id = (select ptpp.party_tax_profile_id
164: from xle_fp_establishment_v est,
165: xle_fp_establishment_v estp,
166: zx_party_tax_profile ptp,
167: zx_party_tax_profile ptpp
168: where estp.party_id = ptpp.party_id
169: and estp.legal_entity_id = est.legal_entity_id
170: and est.party_id = ptp.party_id
171: and ptp.party_tax_profile_id = c_ptp_id

Line 387: ZX_PARTY_TAX_PROFILE ZXP

383: INTO l_party_name, l_party_site_name
384: FROM ZX_REGISTRATIONS REG,
385: HZ_PARTY_SITES HZS,
386: HZ_PARTIES HZP,
387: ZX_PARTY_TAX_PROFILE ZXP
388: WHERE HZP.PARTY_ID = HZS.PARTY_ID
389: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
390: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
391: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

Line 393: FROM ZX_PARTY_TAX_PROFILE S,

389: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
390: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
391: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
392: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
393: FROM ZX_PARTY_TAX_PROFILE S,
394: ZX_PARTY_TAX_PROFILE PTP,
395: HZ_PARTY_SITES HZPS
396: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
397: AND PTP.PARTY_ID = HZPS.PARTY_ID

Line 394: ZX_PARTY_TAX_PROFILE PTP,

390: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
391: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
392: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
393: FROM ZX_PARTY_TAX_PROFILE S,
394: ZX_PARTY_TAX_PROFILE PTP,
395: HZ_PARTY_SITES HZPS
396: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
397: AND PTP.PARTY_ID = HZPS.PARTY_ID
398: AND HZPS.PARTY_SITE_ID = S.PARTY_ID

Line 432: ZX_PARTY_TAX_PROFILE ZXP

428: SELECT HZP.PARTY_NAME
429: INTO l_party_name
430: FROM ZX_REGISTRATIONS REG,
431: HZ_PARTIES HZP,
432: ZX_PARTY_TAX_PROFILE ZXP
433: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
434: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
435: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
436: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID

Line 437: FROM ZX_PARTY_TAX_PROFILE S,

433: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
434: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
435: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
436: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
437: FROM ZX_PARTY_TAX_PROFILE S,
438: ZX_PARTY_TAX_PROFILE PTP,
439: HZ_PARTY_SITES HZPS
440: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
441: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID

Line 438: ZX_PARTY_TAX_PROFILE PTP,

434: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
435: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
436: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
437: FROM ZX_PARTY_TAX_PROFILE S,
438: ZX_PARTY_TAX_PROFILE PTP,
439: HZ_PARTY_SITES HZPS
440: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
441: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
442: AND HZPS.PARTY_ID = S.PARTY_ID

Line 725: ZX_PARTY_TAX_PROFILE PTP

721: BEGIN
722: SELECT COUNT(REG.REGISTRATION_NUMBER)
723: INTO l_total_count
724: FROM ZX_REGISTRATIONS REG,
725: ZX_PARTY_TAX_PROFILE PTP
726: WHERE PTP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
727: AND REG.REGISTRATION_NUMBER = l_trn
728: AND SYSDATE >= REG.EFFECTIVE_FROM
729: AND (SYSDATE <= REG.EFFECTIVE_TO OR REG.EFFECTIVE_TO IS NULL)

Line 752: FROM ZX_PARTY_TAX_PROFILE S,

748: SELECT COUNT(REGISTRATION_NUMBER)
749: INTO l_specific_count
750: FROM ZX_REGISTRATIONS REG
751: WHERE REG.PARTY_TAX_PROFILE_ID IN (SELECT S.PARTY_TAX_PROFILE_ID
752: FROM ZX_PARTY_TAX_PROFILE S,
753: ZX_PARTY_TAX_PROFILE PTP,
754: HZ_PARTY_SITES HZPS
755: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
756: AND PTP.PARTY_ID = HZPS.PARTY_ID

Line 753: ZX_PARTY_TAX_PROFILE PTP,

749: INTO l_specific_count
750: FROM ZX_REGISTRATIONS REG
751: WHERE REG.PARTY_TAX_PROFILE_ID IN (SELECT S.PARTY_TAX_PROFILE_ID
752: FROM ZX_PARTY_TAX_PROFILE S,
753: ZX_PARTY_TAX_PROFILE PTP,
754: HZ_PARTY_SITES HZPS
755: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
756: AND PTP.PARTY_ID = HZPS.PARTY_ID
757: AND HZPS.PARTY_SITE_ID = S.PARTY_ID