APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_OPERATION_INSTANCES

Line 6432: FROM okc_operation_instances op,

6428: IS
6429: CURSOR check_renewal_link
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

Line 6446: FROM okc_operation_instances op,

6442:
6443: CURSOR check_source_link (p_line_id NUMBER)
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

Line 6460: FROM okc_operation_instances op,

6456:
6457: CURSOR check_split_source_link (p_line_id NUMBER)
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

Line 6499: FROM okc_operation_instances op,

6495: IS
6496: CURSOR check_source_link
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

Line 7587: FROM okc_operation_instances op, okc_operation_lines ol

7583:
7584: CURSOR check_renewal_link (p_line_id NUMBER)
7585: IS
7586: SELECT object_cle_id
7587: FROM okc_operation_instances op, okc_operation_lines ol
7588: WHERE ol.oie_id = op.ID
7589: AND op.cop_id IN (41, 40)
7590: AND ol.subject_cle_id = p_line_id;
7591:

Line 7595: FROM okc_operation_instances op, okc_operation_lines ol

7591:
7592: CURSOR check_replace_link (p_line_id NUMBER)
7593: IS
7594: SELECT object_cle_id
7595: FROM okc_operation_instances op, okc_operation_lines ol
7596: WHERE ol.oie_id = op.ID
7597: AND op.cop_id = 11017
7598: AND ol.subject_cle_id = p_line_id;
7599:

Line 9420: FROM okc_operation_instances op,

9416: IS
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'

Line 9432: FROM okc_operation_instances op,

9428:
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'

Line 9443: From Okc_operation_instances

9439: AND op.cop_id = classopr.ID;
9440:
9441: /*
9442: Select id
9443: From Okc_operation_instances
9444: Where target_chr_id = p_target_chr_id
9445: And cop_id in (40,41);
9446: */
9447: l_oper_inst_id NUMBER;