DBA Data[Home] [Help]

APPS.OKC_TERMINATE_PVT dependencies on OKC_K_LINES_V

Line 555: FROM okc_k_lines_v cle,

551: cle.object_version_number,
552: sts.ste_code,
553: cle.start_date,
554: cle.end_date
555: FROM okc_k_lines_v cle,
556: okc_statuses_b sts
557: WHERE cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
558: AND cle.sts_code = sts.code
559: AND cle.date_terminated is null

Line 1402: l_kl_sts_code okc_k_lines_v.sts_code%type;

1398: AND k.scs_code = scs.code;
1399:
1400: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1401: l_contract_number okc_k_headers_v.contract_number%type;
1402: l_kl_sts_code okc_k_lines_v.sts_code%type;
1403:
1404: l_scs_code okc_subclasses_v.code%type;
1405: l_cls_code okc_subclasses_v.cls_code%type;
1406: l_price_negotiated number;