APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on STANDARD

Line 729: c.standard_terms payment_term_id

725: --added for rules migration
726: CURSOR cur_address_billto(p_contract_id IN VARCHAR2) IS
727: SELECT a.cust_acct_id cust_account_id,
728: b.cust_acct_site_id,
729: c.standard_terms payment_term_id
730: FROM okc_k_headers_v a,
731: okx_cust_site_uses_v b,
732: hz_customer_profiles c
733: WHERE a.id = p_contract_id

Line 810: -- Tax Cursor for Exempt Or Standard

806:
807: --End code added by pgomes on 20-NOV-2002
808:
809: /* 5162232 Start
810: -- Tax Cursor for Exempt Or Standard
811: CURSOR astx_csr ( p_khr_id NUMBER ) IS
812: SELECT rule_information1
813: FROM OKC_RULES_B rul,
814: Okc_rule_groups_B rgp

Line 821: -- Tax Cursor for Exempt Or Standard at Line level

817: rgp.dnz_chr_id = rgp.chr_id AND
818: rul.rule_information_category = 'LAASTX' AND
819: rgp.dnz_chr_id = p_khr_id;
820:
821: -- Tax Cursor for Exempt Or Standard at Line level
822: CURSOR astx_line_csr ( p_khr_id NUMBER, p_cle_id NUMBER ) IS
823: SELECT rule_information1
824: FROM OKC_RULES_B rul,
825: Okc_rule_groups_B rgp

Line 1498: -- Set Tax exempt flag to Standard

1494: OPEN astx_line_csr( ln_dtls_rec.contract_id, ln_dtls_rec.kle_id );
1495: FETCH astx_line_csr INTO l_asst_line_tax;
1496: CLOSE astx_line_csr;
1497:
1498: -- Set Tax exempt flag to Standard
1499: l_xsiv_rec.tax_exempt_flag := 'S';
1500: l_xsiv_rec.tax_exempt_reason_code := NULL;
1501:
1502: IF l_asst_tax IS NOT NULL THEN

Line 1561: */ -- Set Tax exempt flag to Standard

1557: END IF;
1558: END IF;
1559: END IF;
1560: -- End Tax Code addition
1561: */ -- Set Tax exempt flag to Standard
1562: xsi_tbl(l_xsi_cnt).tax_exempt_flag := 'S';
1563: xsi_tbl(l_xsi_cnt).tax_exempt_reason_code := NULL;
1564: -- 5162232 End
1565: -- Updated after consolidation

Line 2584: -- Set Tax exempt flag to Standard

2580: OPEN astx_line_csr( ln_no_dtls_rec.contract_id, ln_no_dtls_rec.kle_id );
2581: FETCH astx_line_csr INTO l_asst_line_tax;
2582: CLOSE astx_line_csr;
2583:
2584: -- Set Tax exempt flag to Standard
2585: l_xsiv_rec.tax_exempt_flag := 'S';
2586: l_xsiv_rec.tax_exempt_reason_code := NULL;
2587:
2588: IF l_asst_tax IS NOT NULL THEN

Line 2647: 5162232 End*/ -- Set Tax exempt flag to Standard

2643: END IF;
2644: END IF;
2645: END IF;
2646: -- End Tax Code addition
2647: 5162232 End*/ -- Set Tax exempt flag to Standard
2648: xsi_tbl(l_xsi_cnt).tax_exempt_flag := 'S';
2649: xsi_tbl(l_xsi_cnt).tax_exempt_reason_code := NULL;
2650: -- 5162232 End
2651: -- Updated after consolidation