DBA Data[Home] [Help]

APPS.OKL_VP_TERMINATE_PVT dependencies on OKC_CLASS_OPERATIONS

Line 60: okc_operation_instances B,okc_class_operations C

56:
57: CURSOR cur_old_contract(p_chr_id number) IS
58: SELECT k.contract_number,k.contract_number_modifier
59: FROM okc_k_headers_b K,okc_operation_lines A,
60: okc_operation_instances B,okc_class_operations C
61: WHERE K.id=A.subject_chr_id
62: AND A.object_chr_id=p_chr_id AND
63: C.id=B.cop_id and C.opn_code='RENEWAL'
64: AND B.id=A.oie_id AND A.active_yn='Y' AND