APPS.OKC_TERMINATE_PVT dependencies on OKC_STATUSES_B

Line 35: FROM okc_statuses_b

31: WHERE id = p_chr_id;
32:
33: CURSOR c_sts(p_code IN VARCHAR2) IS
34: SELECT ste_code
35: FROM okc_statuses_b
36: WHERE code = p_code;
37:
38: CURSOR c_invoice(p_code IN VARCHAR2,p_sts_code IN VARCHAR2) IS
39: SELECT allowed_yn

Line 166: FROM okc_statuses_b

162: WHERE id = p_cle_id;
163:
164: CURSOR c_sts(p_code IN VARCHAR2) IS
165: SELECT ste_code
166: FROM okc_statuses_b
167: WHERE code = p_code;
168:
169: CURSOR c_invoice(p_code IN VARCHAR2,p_sts_code IN VARCHAR2) IS
170: SELECT allowed_yn

Line 556: okc_statuses_b sts

552: sts.ste_code,
553: cle.start_date,
554: cle.end_date
555: FROM okc_k_lines_v cle,
556: okc_statuses_b sts
557: WHERE cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
558: AND cle.sts_code = sts.code
559: AND cle.date_terminated is null
560: FOR update of line_number nowait;

Line 583: okc_statuses_b sts,

579: cle.start_date,
580: cle.end_date
581: FROM okc_k_lines_b cle,
582: okc_line_styles_b lse,
583: okc_statuses_b sts,
584: okc_k_headers_b k,
585: okc_assents a,
586: okc_operations_b opn,
587: okc_val_line_operations lopn

Line 1431: FROM okc_statuses_b

1427: */
1428:
1429: CURSOR cur_status (p_code in varchar2) is
1430: SELECT ste_code
1431: FROM okc_statuses_b
1432: WHERE code = p_code;
1433:
1434: l_clev_tbl okc_contract_pub.clev_tbl_type;
1435: i_clev_tbl okc_contract_pub.clev_tbl_type;