APPS.ZX_TRN_VALIDATION_PKG dependencies on ZX_REGISTRATIONS

Line 104: FROM zx_registrations reg,

100:
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

Line 148: from zx_registrations

144:
145:
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

Line 162: from zx_registrations regt

158:
159: CURSOR c_establishment_reg_num (c_ptp_id number, c_tax_reg_num varchar2) IS
160:
161: select regt.registration_number
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,

Line 384: FROM ZX_REGISTRATIONS REG,

380: HZP.ADDRESS4||' '||
381: HZP.CITY||' '||
382: HZP.STATE) PARTY_SITE_NAME
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

Line 430: FROM ZX_REGISTRATIONS REG,

426: AND lookup_code = 'THIRD_PARTY';
427:
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

Line 724: FROM ZX_REGISTRATIONS REG,

720: -- Added for Cross Registration number validation (6774002)
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

Line 750: FROM ZX_REGISTRATIONS REG

746: IF L_PARTY_TYPE_CODE = 'THIRD_PARTY' THEN
747: BEGIN
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