DBA Data[Home] [Help]

APPS.ZX_TRN_VALIDATION_PKG dependencies on ZX_TAXES_B

Line 165: FROM zx_taxes_b

161:
162:
163: CURSOR c_AllowDupRegnNum IS
164: SELECT allow_dup_regn_num_flag
165: FROM zx_taxes_b
166: WHERE tax_regime_code = p_tax_regime_code
167: AND tax = p_tax;
168:
169:

Line 1066: FROM zx_registrations reg, zx_taxes_b t

1062: IF p_tax_regime_code IS NULL THEN
1063: BEGIN
1064: SELECT allow_dup_regn_num_flag
1065: INTO l_allow_regn_num_flag
1066: FROM zx_registrations reg, zx_taxes_b t
1067: WHERE reg.party_tax_profile_id = NVL(p_ptp_id,G_INVALID_PTP_ID)
1068: AND reg.registration_number = p_tax_reg_num
1069: AND TRUNC(sysdate) between reg.effective_from and NVL(reg.effective_to,sysdate+1)
1070: AND t.tax_regime_code = reg.tax_regime_code

Line 1085: FROM zx_registrations reg,zx_taxes_b t,zx_party_tax_profile ptp

1081: END;
1082: BEGIN
1083: SELECT t.allow_dup_regn_num_flag
1084: INTO l_allow_regn_num_flag
1085: FROM zx_registrations reg,zx_taxes_b t,zx_party_tax_profile ptp
1086: WHERE ptp.party_tax_profile_id = NVL(p_ptp_id,G_INVALID_PTP_ID)
1087: AND ptp.rep_registration_number = p_tax_reg_num
1088: AND reg.registration_number = p_tax_reg_num
1089: AND reg.party_tax_profile_id <> p_ptp_id