DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_OPERATION_INSTANCES

Line 1407: okc_operation_instances oi,

1403: -- Get original contract number and modifier of the renewed contract
1404: CURSOR l_old_k_num(p_chr_id NUMBER) IS
1405: SELECT decode(kh.contract_number_modifier,NULL,kh.contract_number, kh.contract_number||' - '|| kh.contract_number_modifier)
1406: FROM okc_operation_lines ol,
1407: okc_operation_instances oi,
1408: okc_class_operations co,
1409: okc_k_headers_all_b kh
1410: WHERE co.cls_code = 'SERVICE'
1411: AND co.opn_code = 'RENEWAL'