APPS.OKC_EXTEND_PVT dependencies on OKC_K_HEADERS_V

Line 1170: FROM okc_k_headers_v

1166: STS_CODE,
1167: CONTRACT_NUMBER,
1168: CONTRACT_NUMBER_MODIFIER,
1169: END_DATE
1170: FROM okc_k_headers_v
1171: WHERE id = p_extend_in_parameters_rec.p_contract_id
1172: and trunc(start_date) = trunc(p_extend_in_parameters_rec.p_orig_start_date)
1173: and trunc(end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
1174: FOR UPDATE OF start_date NOWAIT;

Line 1199: l_k_status_code okc_k_headers_v.sts_code%type;

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.
1203:

Line 1539: l_contract_number okc_k_headers_v.contract_number%type;

1535: AND cle.chr_id = k.id
1536: AND cle.id = p_extend_in_parameters_rec.p_cle_id
1537: AND k.scs_code = scs.code;
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;

Line 1540: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;

1536: AND cle.id = p_extend_in_parameters_rec.p_cle_id
1537: AND k.scs_code = scs.code;
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;