APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_CLASS_OPERATIONS

Line 1014: FROM okc_class_operations

1010: IS
1011: CURSOR cop_csr (p_opn_code VARCHAR2)
1012: IS
1013: SELECT ID
1014: FROM okc_class_operations
1015: WHERE cls_code = (SELECT cls_code
1016: FROM okc_subclasses_b
1017: WHERE code = 'SERVICE')
1018: AND opn_code = p_opn_code;

Line 6473: FROM okc_class_operations

6469: IS
6470: CURSOR cop_csr (p_opn_code VARCHAR2)
6471: IS
6472: SELECT ID
6473: FROM okc_class_operations
6474: WHERE cls_code = (SELECT cls_code
6475: FROM okc_subclasses_b
6476: WHERE code = 'SERVICE')
6477: AND opn_code = p_opn_code;

Line 6602: okc_class_operations classopr,

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'
6606: AND classopr.cls_code = subclass.cls_code

Line 6616: okc_class_operations cl,

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
6620: AND cl.cls_code = sl.cls_code

Line 6630: okc_class_operations cl,

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
6634: AND op.cop_id = cl.ID

Line 6669: okc_class_operations classopr,

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'
6673: AND classopr.cls_code = subclass.cls_code

Line 9665: okc_class_operations classopr,

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'
9669: AND classopr.cls_code = subclass.cls_code

Line 9677: okc_class_operations classopr,

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'
9681: AND classopr.cls_code = subclass.cls_code