DBA Data[Home] [Help]

APPS.OKC_TERMINATE_PVT dependencies on OKC_CLASS_OPERATIONS

Line 335: okc_operation_instances b,okc_class_operations c

331:
332: Cursor cur_old_contract(p_chr_id number) is
333: select k.contract_number,k.contract_number_modifier
334: from okc_k_headers_b k,okc_operation_lines a,
335: okc_operation_instances b,okc_class_operations c
336: where k.id=a.subject_chr_id
337: and a.object_chr_id=p_chr_id and
338: c.id=b.cop_id and c.opn_code='RENEWAL'
339: and b.id=a.oie_id and a.active_yn='Y' and

Line 1182: okc_operation_instances b,okc_class_operations c

1178:
1179: Cursor cur_old_contract(p_chr_id number) is
1180: select k.contract_number,k.contract_number_modifier
1181: from okc_k_headers_b k,okc_operation_lines a,
1182: okc_operation_instances b,okc_class_operations c
1183: where k.id=a.subject_chr_id
1184: and a.object_chr_id=p_chr_id and
1185: c.id=b.cop_id and c.opn_code='RENEWAL'
1186: and b.id=a.oie_id and a.active_yn='Y' and