APPS.OKC_EXTEND_PVT dependencies on OKC_CLASS_OPERATIONS

Line 1232: --FROM okc_class_operations

1228: -- Added for providing extend callout - from header - Bug 2346862/2648677
1229: -- Cursor created to get the PDF_ID for Class 'SERVICE'
1230: --CURSOR c_pdf IS
1231: --SELECT pdf_id
1232: --FROM okc_class_operations
1233: --WHERE opn_code = 'EXTEND'
1234: --AND cls_code = 'SERVICE';
1235:
1236: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS

Line 1236: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS

1232: --FROM okc_class_operations
1233: --WHERE opn_code = 'EXTEND'
1234: --AND cls_code = 'SERVICE';
1235:
1236: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS
1237: SELECT pdf_id
1238: FROM okc_class_operations
1239: WHERE opn_code = 'EXTEND'
1240: AND cls_code = p_cls_code;

Line 1238: FROM okc_class_operations

1234: --AND cls_code = 'SERVICE';
1235:
1236: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS
1237: SELECT pdf_id
1238: FROM okc_class_operations
1239: WHERE opn_code = 'EXTEND'
1240: AND cls_code = p_cls_code;
1241:
1242: l_pdf_id NUMBER;

Line 1555: --FROM okc_class_operations

1551: -- Added for providing extend callout - from Line
1552: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 2648677/2346862
1553: --CURSOR c_pdf IS
1554: --SELECT pdf_id
1555: --FROM okc_class_operations
1556: --WHERE opn_code = 'EXTEND'
1557: --AND cls_code = 'SERVICE';
1558:
1559: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS

Line 1559: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS

1555: --FROM okc_class_operations
1556: --WHERE opn_code = 'EXTEND'
1557: --AND cls_code = 'SERVICE';
1558:
1559: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS
1560: SELECT pdf_id
1561: FROM okc_class_operations
1562: WHERE opn_code = 'EXTEND'
1563: AND cls_code = p_cls_code;

Line 1561: FROM okc_class_operations

1557: --AND cls_code = 'SERVICE';
1558:
1559: CURSOR c_pdf(p_cls_code okc_class_operations_v.cls_code%type) IS
1560: SELECT pdf_id
1561: FROM okc_class_operations
1562: WHERE opn_code = 'EXTEND'
1563: AND cls_code = p_cls_code;
1564:
1565: l_pdf_id NUMBER;