APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_EXEMPTIONS

Line 88: FROM zx_exemptions

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

Line 559: zx_exemptions

555:
556: Begin
557: select 'Y' into l_exists
558: from
559: zx_exemptions
560: where nvl(tax_rate_code,'X') = nvl(p_tax_rate_code,'X') and
561: effective_from = nvl(l_start_date, trunc(sysdate))
562: and nvl(exempt_certificate_number,'X') = nvl(p_exempt_certificate_number,'X')
563: and exempt_reason_code = p_reason_code

Line 591: SELECT zx_exemptions_s.nextval

587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
588: l_log_msg);
589: END IF;
590:
591: SELECT zx_exemptions_s.nextval
592: INTO x_exemption_rec.exemption_id
593: FROM dual;
594: x_exemption_rec.discount_special_rate := 'DISCOUNT';
595: x_exemption_rec.percent_exempt := 100;

Line 615: INSERT INTO ZX_EXEMPTIONS(

611: 'Bill to party ptp id '|| to_char(p_bill_to_party_ptp_id) || ' ' ||
612: 'Tax Jurisdiction id '|| to_char(l_tax_jurisdiction_id));
613: END IF;
614:
615: INSERT INTO ZX_EXEMPTIONS(
616: TAX_EXEMPTION_ID,
617: EXEMPTION_TYPE_CODE,
618: EXEMPTION_STATUS_CODE,
619: TAX_REGIME_CODE,