APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_CLASS_OPERATIONS

Line 974: FROM okc_class_operations

970: IS
971: CURSOR cop_csr (p_opn_code VARCHAR2)
972: IS
973: SELECT ID
974: FROM okc_class_operations
975: WHERE cls_code = (SELECT cls_code
976: FROM okc_subclasses_b
977: WHERE code = 'SERVICE')
978: AND opn_code = p_opn_code;

Line 6305: FROM okc_class_operations

6301: IS
6302: CURSOR cop_csr (p_opn_code VARCHAR2)
6303: IS
6304: SELECT ID
6305: FROM okc_class_operations
6306: WHERE cls_code = (SELECT cls_code
6307: FROM okc_subclasses_b
6308: WHERE code = 'SERVICE')
6309: AND opn_code = p_opn_code;

Line 6434: okc_class_operations classopr,

6430: IS
6431: SELECT object_cle_id, object_chr_id
6432: FROM okc_operation_instances op,
6433: okc_operation_lines ol,
6434: okc_class_operations classopr,
6435: okc_subclasses_b subclass
6436: WHERE ol.oie_id = op.ID
6437: AND subclass.code = 'SERVICE'
6438: AND classopr.cls_code = subclass.cls_code

Line 6448: okc_class_operations cl,

6444: IS
6445: SELECT subject_cle_id, subject_chr_id
6446: FROM okc_operation_instances op,
6447: okc_operation_lines ol,
6448: okc_class_operations cl,
6449: okc_subclasses_b sl
6450: WHERE ol.oie_id = op.ID
6451: AND op.cop_id = cl.ID
6452: AND cl.cls_code = sl.cls_code

Line 6462: okc_class_operations cl,

6458: IS
6459: SELECT subject_cle_id, subject_chr_id
6460: FROM okc_operation_instances op,
6461: okc_operation_lines ol,
6462: okc_class_operations cl,
6463: okc_subclasses_b sl,
6464: okc_k_items a
6465: WHERE ol.oie_id = op.ID
6466: AND op.cop_id = cl.ID

Line 6501: okc_class_operations classopr,

6497: IS
6498: SELECT 'Y'
6499: FROM okc_operation_instances op,
6500: okc_operation_lines ol,
6501: okc_class_operations classopr,
6502: okc_subclasses_b subclass
6503: WHERE ol.oie_id = op.ID
6504: AND subclass.code = 'SERVICE'
6505: AND classopr.cls_code = subclass.cls_code

Line 9421: okc_class_operations classopr,

9417: CURSOR l_operation_csr
9418: IS
9419: SELECT op.ID
9420: FROM okc_operation_instances op,
9421: okc_class_operations classopr,
9422: okc_subclasses_b subclass
9423: WHERE target_chr_id = p_target_chr_id
9424: AND subclass.code = 'SERVICE'
9425: AND classopr.cls_code = subclass.cls_code

Line 9433: okc_class_operations classopr,

9429: CURSOR l_renewal_csr
9430: IS
9431: SELECT op.ID
9432: FROM okc_operation_instances op,
9433: okc_class_operations classopr,
9434: okc_subclasses_b subclass
9435: WHERE target_chr_id = p_target_chr_id
9436: AND subclass.code = 'SERVICE'
9437: AND classopr.cls_code = subclass.cls_code