APPS.OKC_TERMINATE_PVT dependencies on OKC_SUBCLASSES_B

Line 622: OKC_SUBCLASSES_B SCS

618:
619: CURSOR cur_header_aa IS
620: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
621: FROM OKC_K_HEADERS_B K,
622: OKC_SUBCLASSES_B SCS
623: WHERE k.id = p_terminate_in_parameters_rec.p_contract_id
624: AND k.scs_code = scs.code;
625:
626: -- CURSOR for bug 1982629, TERMINATION OF AN EXPIRED CONTRACT

Line 1393: okc_subclasses_b scs,

1389: CURSOR cur_header is
1390: SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
1391: cle.price_negotiated,cle.sts_code
1392: FROM okc_k_headers_b k,
1393: okc_subclasses_b scs,
1394: okc_k_lines_b cle
1395: WHERE k.id = p_terminate_in_parameters_rec.p_dnz_chr_id
1396: AND cle.chr_id = k.id
1397: AND cle.id = p_terminate_in_parameters_rec.p_cle_id