APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OKC_K_HEADERS_B

Line 55: FROM okc_k_headers_b chrb,

51: chrb.contract_number,
52: khr.id,
53: chrb.scs_code, -- rmunjulu 4622198
54: chrb.org_id --added by akrangan to get the org_id of the contract
55: FROM okc_k_headers_b chrb,
56: okl_k_headers khr,
57: okc_k_lines_b okc
58: WHERE okc.id = p_kle_id
59: AND khr.id = chrb.id

Line 155: l_scs_code okc_k_headers_b.scs_code%TYPE;

151: m NUMBER;
152: --akranagna sla cr end
153:
154: -- rmunjulu 4622198
155: l_scs_code okc_k_headers_b.scs_code%TYPE;
156: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
157: l_inv_acct_code okc_rules_b.rule_information1%TYPE;
158:
159: --akrangan sla cr start

Line 1796: FROM okc_k_headers_b okhv,

1792: -- This curosr is used to get all the instances for a Financial asset
1793: --Changed query to use base tables instead uv for performance
1794: CURSOR l_itemlocation_csr IS
1795: SELECT cii.instance_id instance_id, cii.active_end_date instance_end_date
1796: FROM okc_k_headers_b okhv,
1797: okc_k_lines_b kle_fa,
1798: okc_k_lines_tl klet_fa,
1799: okc_line_styles_b lse_fa,
1800: okc_k_lines_b kle_il,

Line 1850: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr

1846:
1847: -- get the deal type from the contract
1848: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
1849: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
1850: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
1851: WHERE khr.id = cle.chr_id
1852: AND lkhr.id = khr.id
1853: AND cle.id = p_financial_asset_id;
1854:

Line 3615: FROM okc_k_headers_b okhv,

3611: -- This curosr is used to get all the instances for a Financial asset
3612: --Query changed to use base tables instead uv for performance
3613: CURSOR l_itemlocation_csr(p_financial_asset_id NUMBER) IS
3614: SELECT cii.instance_id instance_id, cii.active_end_date instance_end_date
3615: FROM okc_k_headers_b okhv,
3616: okc_k_lines_b kle_fa,
3617: okc_k_lines_tl klet_fa,
3618: okc_line_styles_b lse_fa,
3619: okc_k_lines_b kle_il,

Line 3663: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr

3659:
3660: -- get the deal type from the contract
3661: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
3662: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
3663: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
3664: WHERE khr.id = cle.chr_id
3665: AND lkhr.id = khr.id
3666: AND cle.id = p_financial_asset_id;
3667: