APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_SUBCLASSES_B

Line 1016: FROM okc_subclasses_b

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;
1019:
1020: l_cop_id NUMBER;

Line 6475: FROM okc_subclasses_b

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;
6478:
6479: l_cop_id NUMBER;

Line 6603: okc_subclasses_b subclass

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
6607: AND classopr.opn_code IN ('RENEWAL', 'REN_CON')

Line 6617: okc_subclasses_b sl

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
6621: AND sl.code = 'SERVICE'

Line 6631: okc_subclasses_b sl,

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

Line 6670: okc_subclasses_b subclass

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
6674: AND classopr.opn_code IN ('RENEWAL', 'REN_CON')

Line 9666: okc_subclasses_b subclass

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
9670: AND classopr.opn_code IN ('TRANSFER')

Line 9678: okc_subclasses_b subclass

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
9682: AND classopr.opn_code IN ('RENEWAL', 'REN_CON')