APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_K_HEADERS

Line 1815: OKL_K_HEADERS_V khr

1811: chr.sts_code,
1812: sts.meaning
1813: FROM OKC_K_HEADERS_V chr,
1814: OKC_STATUSES_V sts,
1815: OKL_K_HEADERS_V khr
1816: WHERE chr.id = p_contract_id
1817: AND chr.sts_code = sts.code
1818: AND chr.id = khr.id;
1819:

Line 2541: FROM OKL_K_HEADERS_V

2537: -- Get the K deal_type
2538: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
2539: CURSOR k_deal_type_csr is
2540: SELECT deal_type
2541: FROM OKL_K_HEADERS_V
2542: WHERE id = p_term_rec.p_contract_id;
2543:
2544: k_header_rec k_header_csr%ROWTYPE;
2545: l_lease_loan_type VARCHAR2(30) := '$';

Line 3471: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

3467: sosharma End changes
3468: */
3469: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3470: --**SMODUGA added for ap_invoice lines
3471: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3472: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3473: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3474: --**SMODUGA added for ap_invoice lines
3475: l_quote_number NUMBER;

Line 3472: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

3468: */
3469: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3470: --**SMODUGA added for ap_invoice lines
3471: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3472: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3473: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3474: --**SMODUGA added for ap_invoice lines
3475: l_quote_number NUMBER;
3476: l_api_name CONSTANT VARCHAR2(30) := 'process_discount_subsidy';

Line 3473: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

3469: l_sub_sty_id NUMBER; -- SMODUGA for subsidy stream type id
3470: --**SMODUGA added for ap_invoice lines
3471: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
3472: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
3473: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
3474: --**SMODUGA added for ap_invoice lines
3475: l_quote_number NUMBER;
3476: l_api_name CONSTANT VARCHAR2(30) := 'process_discount_subsidy';
3477: l_api_version CONSTANT NUMBER := 1;

Line 3555: from okl_k_headers

3551: -- get currency conversion info
3552: cursor c_currency_conversion (c_contract_id number) is
3553: select CURRENCY_CONVERSION_TYPE,CURRENCY_CONVERSION_RATE,
3554: CURRENCY_CONVERSION_DATE
3555: from okl_k_headers
3556: where id = c_contract_id;
3557: --**END SMODUGA added for currency conversion info
3558:
3559: -- getting App ID

Line 3582: FROM okl_k_headers khr

3578: --**SMODUGA added for contract product
3579: --getting contract product id
3580: CURSOR pdt_id_csr ( p_khr_id NUMBER ) IS
3581: SELECT khr.pdt_id
3582: FROM okl_k_headers khr
3583: WHERE khr.id = p_khr_id;
3584: --**END SMODUGA added for contract product
3585:
3586: -- Transaction type

Line 4909: FROM OKL_K_HEADERS A,

4905: -- MGAAP start 7263041
4906: CURSOR check_csr(p_chr_id NUMBER) IS
4907: SELECT A.MULTI_GAAP_YN,
4908: B.REPORTING_PDT_ID
4909: FROM OKL_K_HEADERS A,
4910: OKL_PRODUCTS B
4911: WHERE A.ID = p_chr_id
4912: AND A.PDT_ID = B.ID;
4913: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

Line 4913: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

4909: FROM OKL_K_HEADERS A,
4910: OKL_PRODUCTS B
4911: WHERE A.ID = p_chr_id
4912: AND A.PDT_ID = B.ID;
4913: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
4914: l_reporting_pdt_id okl_products.REPORTING_PDT_ID%TYPE;
4915: -- MGAAP end 7263041
4916:
4917: -- bug 9191475 .. start