APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_K_LINES_B

Line 84: okc_k_lines_b cle,

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

Line 99: okc_k_lines_b line

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

Line 171: okc_k_lines_b cleb, -- Top Line

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

Line 172: okc_k_lines_b cle, -- Sub Line

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

Line 187: okc_k_lines_b line

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

Line 1152: FROM okc_k_lines_b CLEB, okl_k_lines KLE

1148:
1149: CURSOR fee_type_csr (p_chr_id NUMBER,
1150: p_cle_id NUMBER) IS
1151: SELECT FEE_TYPE
1152: FROM okc_k_lines_b CLEB, okl_k_lines KLE
1153: WHERE CLEB.dnz_chr_id = p_chr_id
1154: AND KLE.ID = p_cle_id
1155: AND KLE.ID = CLEB.ID;
1156:

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

2187: x_return_status OUT NOCOPY VARCHAR2,
2188: x_msg_count OUT NOCOPY NUMBER,
2189: x_msg_data OUT NOCOPY VARCHAR2,
2190: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2191: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2192: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2193: ) IS
2194: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2195: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

Line 2195: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

2191: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2192: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2193: ) IS
2194: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2195: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2196: SELECT kle.id, kle.amount
2197: FROM okc_k_lines_b cleb,
2198: okl_k_lines kle
2199: WHERE cleb.dnz_chr_id = p_chr_id

Line 2197: FROM okc_k_lines_b cleb,

2193: ) IS
2194: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2195: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2196: SELECT kle.id, kle.amount
2197: FROM okc_k_lines_b cleb,
2198: okl_k_lines kle
2199: WHERE cleb.dnz_chr_id = p_chr_id
2200: AND kle.ID = cleb.ID
2201: AND cleb.CLE_ID = p_kle_id

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

2522: x_return_status OUT NOCOPY VARCHAR2,
2523: x_msg_count OUT NOCOPY NUMBER,
2524: x_msg_data OUT NOCOPY VARCHAR2,
2525: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2526: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2527: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2528: ) IS
2529: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2530: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

Line 2530: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

2526: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2527: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2528: ) IS
2529: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2530: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2531: SELECT kle.id, kle.amount
2532: FROM okc_k_lines_b cleb,
2533: okl_k_lines kle
2534: WHERE cleb.dnz_chr_id = p_chr_id

Line 2532: FROM okc_k_lines_b cleb,

2528: ) IS
2529: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2530: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2531: SELECT kle.id, kle.amount
2532: FROM okc_k_lines_b cleb,
2533: okl_k_lines kle
2534: WHERE cleb.dnz_chr_id = p_chr_id
2535: AND kle.ID = cleb.ID
2536: AND cleb.CLE_ID = p_kle_id