APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_EXEMPTIONS

Line 90: FROM zx_exemptions

86: SELECT tax_exemption_id, exemption_type_code, rate_modifier, apply_to_lower_levels_flag,
87: decode(product_id, null, decode(site_use_id, null, decode(cust_account_id, null,4,3),2), 1) select_order1,
88: decode(exemption_status_code,'PRIMARY',1,'MANUAL',2,'UNAPPROVED',3) select_order2,
89: tax_rate_code, tax_jurisdiction_id, tax_status_code, tax, exempt_reason_code, exempt_certificate_number
90: FROM zx_exemptions
91: WHERE party_tax_profile_id = p_ptp_id
92: AND ((p_exempt_control_flag = 'S' and exemption_status_code = 'PRIMARY' )
93: OR ( p_exempt_control_flag = 'E'
94: AND exemption_status_code IN ( 'PRIMARY', 'MANUAL', 'UNAPPROVED' )

Line 135: FROM zx_exemptions

131: SELECT tax_exemption_id, exemption_type_code, rate_modifier, apply_to_lower_levels_flag,
132: decode(product_id, null, decode(site_use_id, null, decode(cust_account_id, null,4,3),2), 1) select_order1,
133: decode(exemption_status_code,'PRIMARY',1,'MANUAL',2,'UNAPPROVED',3) select_order2,
134: tax_rate_code, tax_jurisdiction_id, tax_status_code, tax, exempt_reason_code, exempt_certificate_number
135: FROM zx_exemptions
136: WHERE party_tax_profile_id = p_ptp_id
137: AND exemption_status_code = 'PRIMARY'
138: AND duplicate_exemption = 0
139: AND tax_regime_code = p_tax_regime_code

Line 170: FROM zx_exemptions

166: SELECT tax_exemption_id, exemption_type_code, rate_modifier, apply_to_lower_levels_flag,
167: decode(product_id, null, decode(site_use_id, null, decode(cust_account_id, null,4,3),2), 1) select_order1,
168: decode(exemption_status_code,'PRIMARY',1,'MANUAL',2,'UNAPPROVED',3) select_order2,
169: tax_rate_code, tax_jurisdiction_id, tax_status_code, tax, exempt_reason_code, exempt_certificate_number
170: FROM zx_exemptions
171: WHERE party_tax_profile_id = p_ptp_id
172: AND exempt_certificate_number IS NULL
173: AND duplicate_exemption = 0
174: AND tax_regime_code = p_tax_regime_code

Line 208: FROM zx_exemptions

204: SELECT tax_exemption_id, exemption_type_code, rate_modifier, apply_to_lower_levels_flag,
205: decode(product_id, null, decode(site_use_id, null, decode(cust_account_id, null,4,3),2), 1) select_order1,
206: decode(exemption_status_code,'PRIMARY',1,'MANUAL',2,'UNAPPROVED',3) select_order2,
207: tax_rate_code, tax_jurisdiction_id, tax_status_code, tax, exempt_reason_code, exempt_certificate_number
208: FROM zx_exemptions
209: WHERE party_tax_profile_id = p_ptp_id
210: AND exemption_status_code IN ( 'PRIMARY', 'MANUAL', 'UNAPPROVED' )
211: AND exempt_reason_code = p_reason_code
212: AND rtrim(ltrim(exempt_certificate_number)) = p_exempt_certificate_number

Line 897: zx_exemptions

893:
894: Begin
895: select 'Y' into l_exists
896: from
897: zx_exemptions
898: where nvl(tax_rate_code,'X') = nvl(p_tax_rate_code,'X') and
899: effective_from = nvl(l_start_date, trunc(sysdate))
900: and nvl(exempt_certificate_number,'X') = nvl(p_exempt_certificate_number,'X')
901: and exempt_reason_code = p_reason_code

Line 929: SELECT zx_exemptions_s.nextval

925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
926: l_log_msg);
927: END IF;
928:
929: SELECT zx_exemptions_s.nextval
930: INTO x_exemption_rec.exemption_id
931: FROM dual;
932: x_exemption_rec.discount_special_rate := 'DISCOUNT';
933: x_exemption_rec.percent_exempt := 100;

Line 953: INSERT INTO ZX_EXEMPTIONS(

949: 'Bill to party ptp id '|| to_char(p_bill_to_party_ptp_id) || ' ' ||
950: 'Tax Jurisdiction id '|| to_char(l_tax_jurisdiction_id));
951: END IF;
952:
953: INSERT INTO ZX_EXEMPTIONS(
954: TAX_EXEMPTION_ID,
955: EXEMPTION_TYPE_CODE,
956: EXEMPTION_STATUS_CODE,
957: TAX_REGIME_CODE,