DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 43: FROM OKC_K_HEADERS_B K,

39: -- End of comments
40:
41: CURSOR cur_header_aa (p_contract_id number)IS
42: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
43: FROM OKC_K_HEADERS_B K,
44: OKC_SUBCLASSES_B SCS
45: WHERE k.id = p_contract_id
46: AND k.scs_code = scs.code;
47:

Line 1226: from okc_k_headers_b k,

1222: nowait;
1223: Cursor Cur_header is
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

Line 1321: from okc_k_headers_b k,

1317: nowait;
1318: Cursor Cur_header is
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