eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKL_K_LINES

Line 163: p_cle_id IN OKL_K_LINES.ID%TYPE,

159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
163: p_cle_id IN OKL_K_LINES.ID%TYPE,
164: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
165: x_rule_present OUT NOCOPY VARCHAR2) IS
166: l_proc_name VARCHAR2(35) := 'CHECK_RO_SUBLINE_RULE';
167:

Line 169: p_cle_id OKL_K_LINES.ID%TYPE,

165: x_rule_present OUT NOCOPY VARCHAR2) IS
166: l_proc_name VARCHAR2(35) := 'CHECK_RO_SUBLINE_RULE';
167:
168: CURSOR l_ro_sl_rule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
169: p_cle_id OKL_K_LINES.ID%TYPE,
170: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
171:
172: SELECT 'Y'
173: FROM okc_rules_v rule,

Line 261: FROM okl_k_lines_full_v okl1, -- fee sub line

257: l_cap_amount NUMBER;
258:
259: CURSOR cap_csr (p_fin_line_id NUMBER) IS
260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream

Line 262: okl_k_lines_full_v okl2, -- fee top line

258:
259: CURSOR cap_csr (p_fin_line_id NUMBER) IS
260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream
266: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454

Line 1156: FROM okc_k_lines_b CLEB, okl_k_lines KLE

1152:
1153: CURSOR fee_type_csr (p_chr_id NUMBER,
1154: p_cle_id NUMBER) IS
1155: SELECT FEE_TYPE
1156: FROM okc_k_lines_b CLEB, okl_k_lines KLE
1157: WHERE CLEB.dnz_chr_id = p_chr_id
1158: AND KLE.ID = p_cle_id
1159: AND KLE.ID = CLEB.ID;
1160:

Line 1179: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE;

1175: l_sll_rulv_rec rulv_rec_type;
1176: l_fee_line_capital_amount NUMBER;
1177: l_line_capital_amount NUMBER;
1178: l_rgp_id NUMBER;
1179: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE;
1180: rule_failed EXCEPTION;
1181:
1182: BEGIN
1183: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1470: FROM okl_k_lines_full_v line

1466:
1467: -- Total Capital amount from Financial Asset Top line
1468: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1469: SELECT SUM(NVL(line.capital_amount,0))
1470: FROM okl_k_lines_full_v line
1471: WHERE line.dnz_chr_id = p_chr_id
1472: AND EXISTS ( SELECT 'Y'
1473: FROM okc_line_styles_v style
1474: WHERE line.lse_id = style.id

Line 1579: FROM okc_k_lines_b CLEB, okl_k_lines KLE

1575:
1576: CURSOR fee_type_csr (p_chr_id NUMBER,
1577: p_cle_id NUMBER) IS
1578: SELECT FEE_TYPE
1579: FROM okc_k_lines_b CLEB, okl_k_lines KLE
1580: WHERE CLEB.dnz_chr_id = p_chr_id
1581: AND KLE.ID = p_cle_id
1582: AND KLE.ID = CLEB.ID;
1583:

Line 1885: FROM okl_k_lines_full_v okl,

1881: ) IS
1882: --Changed query for performance --dkagrawa
1883: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1884: SELECT okl.id, okl.capital_amount -- bug# 7661717
1885: FROM okl_k_lines_full_v okl,
1886: okc_line_styles_b ols,
1887: okc_statuses_b okcsts
1888: WHERE okl.dnz_chr_id = p_chr_id
1889: AND okl.lse_id = ols.id

Line 2217: FROM okl_k_lines_full_v okl,

2213: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2214: ) IS
2215: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2216: SELECT okl.id, okl.capital_amount
2217: FROM okl_k_lines_full_v okl,
2218: okc_line_styles_v ols,
2219: okc_rule_groups_b rgp,
2220: okc_rules_b rul
2221: WHERE okl.dnz_chr_id = p_chr_id

Line 2257: FROM okl_k_lines_full_v line,

2253: AND rg.id = p_rgp_id;
2254:
2255: CURSOR line_cap_csr (p_chr_id NUMBER) IS
2256: SELECT SUM(NVL(line.oec,0)) tot_cap
2257: FROM okl_k_lines_full_v line,
2258: okc_line_styles_v style,
2259: okc_statuses_v okcsts,
2260: okc_rules_b rule,
2261: okc_rule_groups_b rgp

Line 2558: okl_k_lines kle

2554: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2555: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2556: SELECT kle.id, kle.amount
2557: FROM okc_k_lines_b cleb,
2558: okl_k_lines kle
2559: WHERE cleb.dnz_chr_id = p_chr_id
2560: AND kle.ID = cleb.ID
2561: AND cleb.CLE_ID = p_kle_id
2562: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 2571: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS

2567: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2568:
2569: -- Total Fee amount for the rollover fee top line.
2570:
2571: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2572: SELECT NVL(kle.amount,0)
2573: FROM okl_k_lines kle
2574: WHERE kle.ID = p_kle_id;
2575:

Line 2573: FROM okl_k_lines kle

2569: -- Total Fee amount for the rollover fee top line.
2570:
2571: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2572: SELECT NVL(kle.amount,0)
2573: FROM okl_k_lines kle
2574: WHERE kle.ID = p_kle_id;
2575:
2576: -- Cursor to get fee top line name.
2577:

Line 2578: CURSOR fee_name_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS

2574: WHERE kle.ID = p_kle_id;
2575:
2576: -- Cursor to get fee top line name.
2577:
2578: CURSOR fee_name_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2579: SELECT kle.name
2580: FROM okc_k_lines_v kle
2581: WHERE kle.ID = p_kle_id;
2582:

Line 2893: okl_k_lines kle

2889: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2890: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2891: SELECT kle.id, kle.amount
2892: FROM okc_k_lines_b cleb,
2893: okl_k_lines kle
2894: WHERE cleb.dnz_chr_id = p_chr_id
2895: AND kle.ID = cleb.ID
2896: AND cleb.CLE_ID = p_kle_id
2897: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 2906: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS

2902: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2903:
2904: -- Total Fee amount for the rollover fee top line.
2905:
2906: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2907: SELECT NVL(kle.amount,0)
2908: FROM okl_k_lines kle
2909: WHERE kle.ID = p_kle_id;
2910:

Line 2908: FROM okl_k_lines kle

2904: -- Total Fee amount for the rollover fee top line.
2905:
2906: CURSOR fee_amount_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2907: SELECT NVL(kle.amount,0)
2908: FROM okl_k_lines kle
2909: WHERE kle.ID = p_kle_id;
2910:
2911: -- Cursor to get fee top line name.
2912:

Line 2913: CURSOR fee_name_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS

2909: WHERE kle.ID = p_kle_id;
2910:
2911: -- Cursor to get fee top line name.
2912:
2913: CURSOR fee_name_csr (p_kle_id OKL_K_LINES.ID%TYPE) IS
2914: SELECT kle.name
2915: FROM okc_k_lines_v kle
2916: WHERE kle.ID = p_kle_id;
2917: