APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_OPERATION_LINES

Line 6601: okc_operation_lines ol,

6597: CURSOR check_renewal_link
6598: IS
6599: SELECT object_cle_id, object_chr_id
6600: FROM okc_operation_instances op,
6601: okc_operation_lines ol,
6602: okc_class_operations classopr,
6603: okc_subclasses_b subclass
6604: WHERE ol.oie_id = op.ID
6605: AND subclass.code = 'SERVICE'

Line 6615: okc_operation_lines ol,

6611: CURSOR check_source_link (p_line_id NUMBER)
6612: IS
6613: SELECT subject_cle_id, subject_chr_id
6614: FROM okc_operation_instances op,
6615: okc_operation_lines ol,
6616: okc_class_operations cl,
6617: okc_subclasses_b sl
6618: WHERE ol.oie_id = op.ID
6619: AND op.cop_id = cl.ID

Line 6629: okc_operation_lines ol,

6625: CURSOR check_split_source_link (p_line_id NUMBER)
6626: IS
6627: SELECT subject_cle_id, subject_chr_id
6628: FROM okc_operation_instances op,
6629: okc_operation_lines ol,
6630: okc_class_operations cl,
6631: okc_subclasses_b sl,
6632: okc_k_items a
6633: WHERE ol.oie_id = op.ID

Line 6668: okc_operation_lines ol,

6664: CURSOR check_source_link
6665: IS
6666: SELECT 'Y'
6667: FROM okc_operation_instances op,
6668: okc_operation_lines ol,
6669: okc_class_operations classopr,
6670: okc_subclasses_b subclass
6671: WHERE ol.oie_id = op.ID
6672: AND subclass.code = 'SERVICE'

Line 7781: FROM okc_operation_instances op, okc_operation_lines ol

7777:
7778: CURSOR check_renewal_link (p_line_id NUMBER)
7779: IS
7780: SELECT object_cle_id
7781: FROM okc_operation_instances op, okc_operation_lines ol
7782: WHERE ol.oie_id = op.ID
7783: AND op.cop_id IN (41, 40)
7784: AND ol.subject_cle_id = p_line_id;
7785:

Line 7789: FROM okc_operation_instances op, okc_operation_lines ol

7785:
7786: CURSOR check_replace_link (p_line_id NUMBER)
7787: IS
7788: SELECT object_cle_id
7789: FROM okc_operation_instances op, okc_operation_lines ol
7790: WHERE ol.oie_id = op.ID
7791: AND op.cop_id = 11017
7792: AND ol.subject_cle_id = p_line_id;
7793: