APPS.OKC_EXTEND_PVT dependencies on OKC_SUBCLASSES_V

Line 1197: l_scs_code okc_subclasses_v.code%type;

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;
1198: l_cls_code okc_subclasses_v.cls_code%type;
1199: l_k_status_code okc_k_headers_v.sts_code%type;
1200: l_estimated_amount number;
1201:

Line 1198: l_cls_code okc_subclasses_v.cls_code%type;

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;
1198: l_cls_code okc_subclasses_v.cls_code%type;
1199: l_k_status_code okc_k_headers_v.sts_code%type;
1200: l_estimated_amount number;
1201:
1202: -- Bring only those line that have the same end date as of the header.

Line 1542: l_scs_code okc_subclasses_v.code%type;

1538:
1539: l_contract_number okc_k_headers_v.contract_number%type;
1540: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1541: l_kl_sts_code okc_k_lines_v.sts_code%type;
1542: l_scs_code okc_subclasses_v.code%type;
1543: l_cls_code okc_subclasses_v.cls_code%type;
1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;
1546: l_cle_rec okc_contract_pub.clev_rec_type;

Line 1543: l_cls_code okc_subclasses_v.cls_code%type;

1539: l_contract_number okc_k_headers_v.contract_number%type;
1540: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1541: l_kl_sts_code okc_k_lines_v.sts_code%type;
1542: l_scs_code okc_subclasses_v.code%type;
1543: l_cls_code okc_subclasses_v.cls_code%type;
1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;
1546: l_cle_rec okc_contract_pub.clev_rec_type;
1547: l_status varchar2(30);