APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_CHANGE_REQUESTS_B

Line 65: FROM OKC_CHANGE_REQUESTS_B where

61:
62: --san
63: Cursor cur_chg(chq_id number) IS
64: Select datetime_request
65: FROM OKC_CHANGE_REQUESTS_B where
66: ID=chq_id;
67: l_chgreq_date OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE;
68: --end san
69:

Line 943: OKC_CHANGE_REQUESTS_B C,

939: --
940: cursor in_use_csr is
941: select '!'
942: from
943: OKC_CHANGE_REQUESTS_B C,
944: OKC_K_PROCESSES P
945: where C.chr_id = (select chr_id from OKC_CHANGE_REQUESTS_B
946: where id = p_change_request_id)
947: and C.ID <> p_change_request_id

Line 945: where C.chr_id = (select chr_id from OKC_CHANGE_REQUESTS_B

941: select '!'
942: from
943: OKC_CHANGE_REQUESTS_B C,
944: OKC_K_PROCESSES P
945: where C.chr_id = (select chr_id from OKC_CHANGE_REQUESTS_B
946: where id = p_change_request_id)
947: and C.ID <> p_change_request_id
948: and C.datetime_applied is NULL
949: and P.crt_id = C.id

Line 1219: from okc_change_requests_B

1215: l_msg_count NUMBER;
1216: l_msg_data varchar2(2000);
1217: cursor lock_csr is
1218: select ID
1219: from okc_change_requests_B
1220: where ID = p_change_request_id
1221: for update of crs_code, datetime_approved, datetime_rejected
1222: nowait;
1223: Cursor Cur_header is

Line 1228: okc_change_requests_b crt

1224: select k.id,k.contract_number,k.contract_number_modifier,k.scs_code,
1225: scs.cls_code,k.estimated_amount,k.sts_code
1226: from okc_k_headers_b k,
1227: okc_subclasses_b scs,
1228: okc_change_requests_b crt
1229: where crt.chr_id = k.id
1230: and k.scs_code = scs.code
1231: and crt.id = p_change_request_id;
1232: l_chr_id number;

Line 1314: from okc_change_requests_b

1310: l_msg_count NUMBER;
1311: l_msg_data varchar2(2000);
1312: cursor lock_csr is
1313: select ID
1314: from okc_change_requests_b
1315: where ID = p_change_request_id
1316: for update of crs_code, datetime_approved, datetime_rejected
1317: nowait;
1318: Cursor Cur_header is

Line 1323: okc_change_requests_b crt

1319: select k.id,k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
1320: k.estimated_amount,k.sts_code
1321: from okc_k_headers_b k,
1322: okc_subclasses_b scs,
1323: okc_change_requests_b crt
1324: where crt.chr_id = k.id
1325: and k.scs_code = scs.code
1326: and crt.id = p_change_request_id;
1327: