APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKC_K_LINES_B

Line 578: from okc_k_lines_b cle

574: --avsingh
575: Cursor l_lock_cle_csr(CleId IN NUMBER) is
576: Select cle.id,
577: cle.last_update_date
578: from okc_k_lines_b cle
579: where cle.id = CleId
580: for update of cle.last_update_date nowait;
581:
582: l_cle_id number;

Line 1282: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS

1278: WHERE dnz_chr_id = p_chr_id AND
1279: rgd_code = p_rgd_code AND
1280: cle_id IS NULL ;
1281:
1282: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
1283: SELECT lty_code
1284: FROM okc_k_lines_b line,
1285: okc_line_styles_b style
1286: WHERE line.lse_id = style.id

Line 1284: FROM okc_k_lines_b line,

1280: cle_id IS NULL ;
1281:
1282: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
1283: SELECT lty_code
1284: FROM okc_k_lines_b line,
1285: okc_line_styles_b style
1286: WHERE line.lse_id = style.id
1287: AND line.id = p_line_id;
1288:

Line 1292: p_line_id okc_k_lines_b.id%TYPE) IS

1288:
1289: l_line_style okc_line_styles_b.lty_code%TYPE;
1290:
1291: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
1292: p_line_id okc_k_lines_b.id%TYPE) IS
1293: SELECT rlobj.object1_id1
1294: FROM okc_k_rel_objs_v rlobj
1295: WHERE rlobj.chr_id = p_chr_id
1296: AND rlobj.cle_id = p_line_id

Line 1300: l_service_top_line_id okc_k_lines_b.id%TYPE;

1296: AND rlobj.cle_id = p_line_id
1297: AND rlobj.rty_code = 'OKLSRV'
1298: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
1299:
1300: l_service_top_line_id okc_k_lines_b.id%TYPE;
1301:
1302: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
1303: SELECT dnz_chr_id
1304: FROM okc_k_lines_b

Line 1302: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS

1298: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
1299:
1300: l_service_top_line_id okc_k_lines_b.id%TYPE;
1301:
1302: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
1303: SELECT dnz_chr_id
1304: FROM okc_k_lines_b
1305: WHERE id = p_serv_top_line_id;
1306:

Line 1304: FROM okc_k_lines_b

1300: l_service_top_line_id okc_k_lines_b.id%TYPE;
1301:
1302: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
1303: SELECT dnz_chr_id
1304: FROM okc_k_lines_b
1305: WHERE id = p_serv_top_line_id;
1306:
1307: l_serv_contract_id okc_k_headers_b.id%TYPE;
1308: