APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_K_HEADERS

Line 1793: OKL_K_HEADERS_V khr

1789: chr.sts_code,
1790: sts.meaning
1791: FROM OKC_K_HEADERS_V chr,
1792: OKC_STATUSES_V sts,
1793: OKL_K_HEADERS_V khr
1794: WHERE chr.id = p_contract_id
1795: AND chr.sts_code = sts.code
1796: AND chr.id = khr.id;
1797:

Line 2519: FROM OKL_K_HEADERS_V

2515: -- Get the K deal_type
2516: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
2517: CURSOR k_deal_type_csr is
2518: SELECT deal_type
2519: FROM OKL_K_HEADERS_V
2520: WHERE id = p_term_rec.p_contract_id;
2521:
2522: k_header_rec k_header_csr%ROWTYPE;
2523: l_lease_loan_type VARCHAR2(30) := '$';

Line 3449: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

3445: sosharma End changes
3446: */
3447: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3448: --**SMODUGA added for ap_invoice lines
3449: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3450: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3451: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3452: --**SMODUGA added for ap_invoice lines
3453: l_quote_number NUMBER;

Line 3450: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

3446: */
3447: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3448: --**SMODUGA added for ap_invoice lines
3449: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3450: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3451: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3452: --**SMODUGA added for ap_invoice lines
3453: l_quote_number NUMBER;
3454: l_api_name CONSTANT VARCHAR2(30) := 'process_discount_subsidy';

Line 3451: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

3447: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3448: --**SMODUGA added for ap_invoice lines
3449: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3450: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3451: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3452: --**SMODUGA added for ap_invoice lines
3453: l_quote_number NUMBER;
3454: l_api_name CONSTANT VARCHAR2(30) := 'process_discount_subsidy';
3455: l_api_version CONSTANT NUMBER := 1;

Line 3533: from okl_k_headers

3529: -- get currency conversion info
3530: cursor c_currency_conversion (c_contract_id number) is
3531: select CURRENCY_CONVERSION_TYPE,CURRENCY_CONVERSION_RATE,
3532: CURRENCY_CONVERSION_DATE
3533: from okl_k_headers
3534: where id = c_contract_id;
3535: --**END SMODUGA added for currency conversion info
3536:
3537: -- getting App ID

Line 3560: FROM okl_k_headers khr

3556: --**SMODUGA added for contract product
3557: --getting contract product id
3558: CURSOR pdt_id_csr ( p_khr_id NUMBER ) IS
3559: SELECT khr.pdt_id
3560: FROM okl_k_headers khr
3561: WHERE khr.id = p_khr_id;
3562: --**END SMODUGA added for contract product
3563:
3564: -- Transaction type

Line 4887: FROM OKL_K_HEADERS A,

4883: -- MGAAP start 7263041
4884: CURSOR check_csr(p_chr_id NUMBER) IS
4885: SELECT A.MULTI_GAAP_YN,
4886: B.REPORTING_PDT_ID
4887: FROM OKL_K_HEADERS A,
4888: OKL_PRODUCTS B
4889: WHERE A.ID = p_chr_id
4890: AND A.PDT_ID = B.ID;
4891: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

Line 4891: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

4887: FROM OKL_K_HEADERS A,
4888: OKL_PRODUCTS B
4889: WHERE A.ID = p_chr_id
4890: AND A.PDT_ID = B.ID;
4891: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
4892: l_reporting_pdt_id okl_products.REPORTING_PDT_ID%TYPE;
4893: -- MGAAP end 7263041
4894:
4895: BEGIN