APPS.OKL_AM_CONTRACT_PRTFL_PVT dependencies on OKC_K_HEADERS_B

Line 57: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;

53: execution_date_error EXCEPTION;
54:
55: --SECHAWLA Bug # 2726739 : new declarations
56: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
57: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
58: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
59: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
60: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
61: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 75: FROM okc_k_headers_b

71:
72: -- This cursor is used to get the contract end date
73: CURSOR l_okcheaders_csr IS
74: SELECT end_date, contract_number
75: FROM okc_k_headers_b
76: WHERE id = p_contract_id;
77:
78: -- TAPI validation ??
79: -- This cursor is used to validate the contract ID

Line 808: FROM okc_k_headers_b

804:
805: -- This cursor is used to get the contract number for a given contract ID
806: CURSOR l_okcheaders_csr(p_id NUMBER) IS
807: SELECT contract_number
808: FROM okc_k_headers_b
809: WHERE id = p_id;
810:
811: -- This cursor is used to get the formulae id
812: CURSOR l_formulae_csr(p_id NUMBER) IS

Line 1200: FROM okl_prtfl_cntrcts_b h, okl_prtfl_lines_b l, okc_k_headers_b khr

1196:
1197: -- This cursor is used to get the portfolios that need to be executed.
1198: CURSOR l_cntrctprtfl_csr(p_date DATE) IS
1199: SELECT h.id header_id, l.id line_id , h.khr_id khr_id, khr.contract_number contract_number, l.tmb_id
1200: FROM okl_prtfl_cntrcts_b h, okl_prtfl_lines_b l, okc_k_headers_b khr
1201: WHERE h.id = l.pfc_id
1202: AND h.khr_id = khr.id
1203: AND l.date_strategy_executed IS NULL
1204: AND khr.sts_code = 'BOOKED'