DBA Data[Home] [Help]

APPS.OKC_EXTEND_PVT dependencies on OKC_SUBCLASSES_B

Line 1193: OKC_SUBCLASSES_B SCS

1189:
1190: CURSOR cur_header_aa IS
1191: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
1192: FROM OKC_K_HEADERS_B K,
1193: OKC_SUBCLASSES_B SCS
1194: WHERE k.id = p_extend_in_parameters_rec.p_contract_id
1195: AND k.scs_code = scs.code;
1196:
1197: l_scs_code okc_subclasses_v.code%type;

Line 1532: okc_subclasses_b scs,

1528: CURSOR cur_header is
1529: SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
1530: cle.price_negotiated,cle.sts_code
1531: FROM okc_k_headers_b k,
1532: okc_subclasses_b scs,
1533: okc_k_lines_b cle
1534: WHERE k.id = p_extend_in_parameters_rec.p_dnz_chr_id
1535: AND cle.chr_id = k.id
1536: AND cle.id = p_extend_in_parameters_rec.p_cle_id