APPS.OKL_CONS_BILL dependencies on OKL_CNSLD_AR_STRMS_B

Line 37: okl_cnsld_ar_strms_b lsm

33: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
34: SELECT SUM(lsm.amount)
35: FROM okl_cnsld_ar_hdrs_b cnr,
36: okl_cnsld_ar_lines_b lln,
37: okl_cnsld_ar_strms_b lsm
38: WHERE cnr.id = p_cnr_id AND
39: cnr.id = lln.cnr_id AND
40: lln.id = lsm.lln_id;
41:

Line 45: okl_cnsld_ar_strms_b lsm

41:
42: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
43: SELECT SUM(lsm.amount)
44: FROM okl_cnsld_ar_lines_b lln,
45: okl_cnsld_ar_strms_b lsm
46: WHERE lln.id = p_lln_id AND
47: lln.id = lsm.lln_id;
48:
49:

Line 225: DELETE FROM okl_cnsld_ar_strms_b

221: -- ----------------------------------------------
222: -- Delete LSM LLN and CNR records
223: -- ----------------------------------------------
224: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
225: DELETE FROM okl_cnsld_ar_strms_b
226: WHERE id = l_update_tbl(m).lsm_id;
227:
228: DELETE FROM okl_cnsld_ar_strms_tl
229: WHERE id = l_update_tbl(m).lsm_id;

Line 1026: OKL_CNSLD_AR_STRMS_B LSM

1022: OKC_LINE_STYLES_b SUB_LSE,
1023: OKC_K_ITEMS CIM,
1024: OKC_K_LINES_V FA,
1025: OKC_LINE_STYLES_B AST_LSE,
1026: OKL_CNSLD_AR_STRMS_B LSM
1027: WHERE
1028: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
1029: TOP_CLE.LSE_ID = TOP_LSE.ID AND
1030: TOP_LSE.LTY_CODE IN('SOLD_SERVICE','FEE') AND

Line 1098: okl_cnsld_ar_strms_b lsm

1094: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
1095: SELECT SUM(lsm.amount)
1096: FROM okl_cnsld_ar_hdrs_b cnr,
1097: okl_cnsld_ar_lines_b lln,
1098: okl_cnsld_ar_strms_b lsm
1099: WHERE cnr.id = p_cnr_id AND
1100: cnr.id = lln.cnr_id AND
1101: lln.id = lsm.lln_id;
1102:

Line 1106: okl_cnsld_ar_strms_b lsm

1102:
1103: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
1104: SELECT SUM(lsm.amount)
1105: FROM okl_cnsld_ar_lines_b lln,
1106: okl_cnsld_ar_strms_b lsm
1107: WHERE lln.id = p_lln_id AND
1108: lln.id = lsm.lln_id;
1109:
1110: CURSOR strm_csr ( p_id NUMBER ) IS

Line 1914: OKL_CNSLD_AR_STRMS_B LSM

1910:
1911: CURSOR asset_line_csr (p_lsm_id NUMBER) IS
1912: SELECT ASSET_NUMBER
1913: FROM
1914: OKL_CNSLD_AR_STRMS_B LSM
1915: ,OKX_ASSET_LINES_V KLE
1916:
1917: WHERE LSM.ID = p_lsm_id
1918: AND KLE.PARENT_LINE_ID = LSM.KLE_ID;

Line 1930: OKL_CNSLD_AR_STRMS_B LSM

1926: OKC_LINE_STYLES_b SUB_LSE,
1927: OKC_K_ITEMS CIM,
1928: OKC_K_LINES_V FA,
1929: OKC_LINE_STYLES_B AST_LSE,
1930: OKL_CNSLD_AR_STRMS_B LSM
1931: WHERE
1932: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
1933: TOP_CLE.LSE_ID = TOP_LSE.ID AND
1934: TOP_LSE.LTY_CODE IN('SOLD_SERVICE','FEE') AND

Line 2037: FROM okl_cnsld_ar_strms_b

2033: l_temp_khr_id NUMBER;
2034:
2035: CURSOR get_khr_id ( p_lsm_id NUMBER ) IS
2036: SELECT khr_id
2037: FROM okl_cnsld_ar_strms_b
2038: WHERE id = p_lsm_id;
2039:
2040:
2041: -- Variable to track commit record size

Line 2099: okl_cnsld_ar_strms_b lsm

2095: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
2096: SELECT SUM(lsm.amount)
2097: FROM okl_cnsld_ar_hdrs_b cnr,
2098: okl_cnsld_ar_lines_b lln,
2099: okl_cnsld_ar_strms_b lsm
2100: WHERE cnr.id = p_cnr_id AND
2101: cnr.id = lln.cnr_id AND
2102: lln.id = lsm.lln_id;
2103:

Line 2107: okl_cnsld_ar_strms_b lsm

2103:
2104: CURSOR lln_amt_csr ( p_lln_id IN NUMBER ) IS
2105: SELECT SUM(lsm.amount)
2106: FROM okl_cnsld_ar_lines_b lln,
2107: okl_cnsld_ar_strms_b lsm
2108: WHERE lln.id = p_lln_id AND
2109: lln.id = lsm.lln_id;
2110:
2111: -- Start Bug 4731187