APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_OPERATION_INSTANCES

Line 6600: FROM okc_operation_instances op,

6596: IS
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

Line 6614: FROM okc_operation_instances op,

6610:
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

Line 6628: FROM okc_operation_instances op,

6624:
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

Line 6667: FROM okc_operation_instances op,

6663: IS
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

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:

Line 9664: FROM okc_operation_instances op,

9660: IS
9661: CURSOR l_operation_csr
9662: IS
9663: SELECT op.ID
9664: FROM okc_operation_instances op,
9665: okc_class_operations classopr,
9666: okc_subclasses_b subclass
9667: WHERE target_chr_id = p_target_chr_id
9668: AND subclass.code = 'SERVICE'

Line 9676: FROM okc_operation_instances op,

9672:
9673: CURSOR l_renewal_csr
9674: IS
9675: SELECT op.ID
9676: FROM okc_operation_instances op,
9677: okc_class_operations classopr,
9678: okc_subclasses_b subclass
9679: WHERE target_chr_id = p_target_chr_id
9680: AND subclass.code = 'SERVICE'

Line 9687: From Okc_operation_instances

9683: AND op.cop_id = classopr.ID;
9684:
9685: /*
9686: Select id
9687: From Okc_operation_instances
9688: Where target_chr_id = p_target_chr_id
9689: And cop_id in (40,41);
9690: */
9691: l_oper_inst_id NUMBER;