APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_SUBCLASSES_B

Line 976: FROM okc_subclasses_b

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;
979:
980: l_cop_id NUMBER;

Line 6307: FROM okc_subclasses_b

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;
6310:
6311: l_cop_id NUMBER;

Line 6435: okc_subclasses_b subclass

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

Line 6449: okc_subclasses_b sl

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

Line 6463: okc_subclasses_b sl,

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

Line 6502: okc_subclasses_b subclass

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

Line 9422: okc_subclasses_b subclass

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

Line 9434: okc_subclasses_b subclass

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