APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_OPERATION_LINES

Line 6433: okc_operation_lines ol,

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
6437: AND subclass.code = 'SERVICE'

Line 6447: okc_operation_lines ol,

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

Line 6461: okc_operation_lines ol,

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
6465: WHERE ol.oie_id = op.ID

Line 6500: okc_operation_lines ol,

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
6504: AND subclass.code = 'SERVICE'

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: