APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_STATUSES_B

Line 943: okc_statuses_b sts,

939: Cursor ln_future_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2 ) IS
940: select NVL(sum(sel.amount), 0) amount
941: from
942: okl_K_lines_full_v kle,
943: okc_statuses_b sts,
944: okl_strm_elements sel,
945: okl_streams stm,
946: okl_strm_type_b sty
947: WHERE kle.dnz_chr_id = p_chr_id

Line 1044: okc_statuses_b sts,

1040: Cursor l_chr_income_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE) IS
1041: select NVL(sum(sel.amount), 0) amount
1042: from
1043: okl_K_lines_full_v kle,
1044: okc_statuses_b sts,
1045: okl_strm_elements sel,
1046: okl_streams stm,
1047: okl_strm_type_b sty
1048: WHERE kle.dnz_chr_id = p_chr_id

Line 1121: okc_statuses_b sts

1117: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1118: SELECT nvl(kle.residual_value,0) Value
1119: FROM OKC_LINE_STYLES_B LS,
1120: okl_K_lines_full_v kle,
1121: okc_statuses_b sts
1122: WHERE LS.ID = KLE.LSE_ID
1123: AND LS.LTY_CODE ='FREE_FORM1'
1124: AND KLE.DNZ_CHR_ID = p_chr_id --289326506849179644190030423574805590144
1125: AND KLE.id = p_kle_id

Line 2304: okc_statuses_b khs,

2300: chr.contract_number,
2301: chr.start_date start_date
2302: FROM okc_k_headers_b chr,
2303: okl_k_headers khr,
2304: okc_statuses_b khs,
2305: okc_rules_b rules,
2306: okc_rule_groups_b rgp
2307: WHERE CHR.CONTRACT_NUMBER = NVL(l_contract_number,CHR.CONTRACT_NUMBER)
2308: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING',

Line 12654: okc_statuses_b khs,

12650: --Bug# 7277007
12651: ppm.name product_name
12652: FROM okc_k_headers_b chr,
12653: okl_k_headers khr,
12654: okc_statuses_b khs,
12655: okl_product_parameters_v ppm
12656: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
12657: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')
12658: AND chr.id = khr.id