APPS.OKC_EXTEND_PVT dependencies on OKC_STATUSES_B

Line 38: FROM okc_statuses_b

34: WHERE id = p_chr_id;
35:
36: CURSOR c_sts(p_code IN VARCHAR2) IS
37: SELECT ste_code
38: FROM okc_statuses_b
39: WHERE code = p_code;
40:
41: BEGIN
42:

Line 130: FROM okc_statuses_b

126: WHERE id = p_cle_id;
127:
128: CURSOR c_sts(p_code IN VARCHAR2) IS
129: SELECT ste_code
130: FROM okc_statuses_b
131: WHERE code = p_code;
132:
133:
134: BEGIN

Line 252: FROM okc_statuses_b

248: AND v.in_process_yn='Y';
249:
250: CURSOR cur_status(p_sts_code varchar2) is
251: SELECT ste_code
252: FROM okc_statuses_b
253: WHERE code = p_sts_code;
254:
255: CURSOR cur_mean(p_sts_code varchar2) is
256: SELECT meaning

Line 417: okc_statuses_b sts

413: CURSOR cur_k_lines is
414: SELECT cle.line_number,cle.item_description,cle.id,cle.lse_id,cle.sts_code,cle.dnz_chr_id,
415: cle.object_version_number,cle.date_terminated,cle.end_date,sts.ste_code
416: FROM okc_k_lines_v cle,
417: okc_statuses_b sts
418: WHERE cle.id = p_extend_in_parameters_rec.p_cle_id
419: AND trunc(cle.end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
420: AND cle.sts_code = sts.code;
421:

Line 607: okc_statuses_b sts

603: -- bug#5757116 added trunc in the where clause of the cursor.
604: CURSOR cur_k_lines is
605: SELECT cle.id
606: FROM okc_k_lines_b cle,
607: okc_statuses_b sts
608: WHERE trunc(cle.end_date) = trunc(p_chr_rec.end_date)
609: AND cle.dnz_chr_id = p_chr_rec.id
610: AND Cle.chr_id is not null
611: AND cle.sts_code = sts.code

Line 622: FROM okc_statuses_b

618: start with id=p_id;
619:
620: CURSOR cur_status(p_sts_code varchar2) is
621: SELECT ste_code
622: FROM okc_statuses_b
623: WHERE code = p_sts_code;
624:
625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;
626: i_chr_rec okc_contract_pub.chrv_rec_type;

Line 1208: okc_statuses_b sts

1204: -- bug # 5757116 Added trunc to the end date in the where clause of the cursor.
1205: CURSOR cur_k_lines(p_chr_id number,p_end_date date) is
1206: SELECT cle.id,cle.end_date,cle.start_date,cle.object_version_number
1207: FROM okc_k_lines_b cle,
1208: okc_statuses_b sts
1209: WHERE cle.dnz_chr_id = p_chr_id
1210: and trunc(cle.end_date) = trunc(p_end_date)
1211: and cle.sts_code = sts.code
1212: and sts.ste_code in ('ACTIVE','EXPIRED','ENTERED','SIGNED')

Line 1223: FROM okc_statuses_b

1219: l_new_end_date date;
1220:
1221: CURSOR cur_status(p_sts_code varchar2) is
1222: SELECT ste_code
1223: FROM okc_statuses_b
1224: WHERE code = p_sts_code;
1225:
1226: l_ste_code okc_statuses_v.ste_code%type;
1227:

Line 1525: FROM okc_statuses_b

1521: FOR UPDATE OF id NOWAIT;
1522:
1523: CURSOR cur_status (p_sts_code okc_statuses_v.code%type) is
1524: SELECT ste_code
1525: FROM okc_statuses_b
1526: WHERE code = p_sts_code;
1527:
1528: CURSOR cur_header is
1529: SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,