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 OKC_K_LINES_B

Line 88: okc_k_lines_b cle,

84: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
85: SELECT 'Y'
86: FROM okc_rules_v rule,
87: okc_rule_groups_v rg,
88: okc_k_lines_b cle,
89: okc_line_styles_b lsb
90: WHERE rule.dnz_chr_id = p_chr_id
91: AND rule_information_category IN ('LASLH','LASLL')
92: AND rule.object1_id1 = p_strm_id

Line 103: okc_k_lines_b line

99: -- added to handle abandon line
100: AND NOT EXISTS (
101: SELECT 'Y'
102: FROM okc_statuses_v okcsts,
103: okc_k_lines_b line
104: WHERE line.id = rg.cle_id
105: AND line.sts_code = okcsts.code
106: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
107:

Line 175: okc_k_lines_b cleb, -- Top Line

171:
172: SELECT 'Y'
173: FROM okc_rules_v rule,
174: okc_rule_groups_v rg,
175: okc_k_lines_b cleb, -- Top Line
176: okc_k_lines_b cle, -- Sub Line
177: okc_line_styles_b lsb
178: WHERE rule.dnz_chr_id = p_chr_id
179: AND rule_information_category IN ('LASLH','LASLL')

Line 176: okc_k_lines_b cle, -- Sub Line

172: SELECT 'Y'
173: FROM okc_rules_v rule,
174: okc_rule_groups_v rg,
175: okc_k_lines_b cleb, -- Top Line
176: okc_k_lines_b cle, -- Sub Line
177: okc_line_styles_b lsb
178: WHERE rule.dnz_chr_id = p_chr_id
179: AND rule_information_category IN ('LASLH','LASLL')
180: AND rule.object1_id1 = p_strm_id

Line 191: okc_k_lines_b line

187: -- added to handle abandon line
188: AND NOT EXISTS (
189: SELECT 'Y'
190: FROM okc_statuses_v okcsts,
191: okc_k_lines_b line
192: WHERE line.id = rg.cle_id
193: AND line.sts_code = okcsts.code
194: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
195:

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 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 2551: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line

2547: x_return_status OUT NOCOPY VARCHAR2,
2548: x_msg_count OUT NOCOPY NUMBER,
2549: x_msg_data OUT NOCOPY VARCHAR2,
2550: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2551: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2552: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2553: ) IS
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

Line 2555: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

2551: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2552: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2553: ) IS
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

Line 2557: FROM okc_k_lines_b cleb,

2553: ) IS
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

Line 2886: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line

2882: x_return_status OUT NOCOPY VARCHAR2,
2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2886: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2887: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2888: ) IS
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

Line 2890: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

2886: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2887: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2888: ) IS
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

Line 2892: FROM okc_k_lines_b cleb,

2888: ) IS
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