APPS.OKS_RENCON_PVT dependencies on OKC_CLASS_OPERATIONS

Line 10: SELECT ID from OKC_CLASS_OPERATIONS

6:
7: --Bug#5981381: Cache the class_operation_id instead of deriving everytime;
8: G_RENCON_CLASS_OPERATION_ID NUMBER;
9: CURSOR cur_class_operations is
10: SELECT ID from OKC_CLASS_OPERATIONS
11: WHERE OPN_CODE = 'REN_CON' and CLS_CODE = 'SERVICE';
12:
13: ----------------------------------------------------------------------------------------
14: ---This function is used to Check if the source_line_id has been processed with another

Line 206: FROM OKC_CLASS_OPERATIONS

202: FROM okc_operation_instances OPI
203: WHERE OPI.id = OPL.oie_id
204: AND OPI.cop_id = G_RENCON_CLASS_OPERATION_ID -- Bug#5981381: Use cached class_operation_id
205: /* (SELECT ID
206: FROM OKC_CLASS_OPERATIONS
207: WHERE OPN_CODE = 'REN_CON'
208: AND CLS_CODE = 'SERVICE'
209: )
210: */

Line 576: /*(SELECT ID FROM OKC_CLASS_OPERATIONS

572: CURSOR oper_inst(p_target_id IN NUMBER) IS
573: SELECT id FROM okc_operation_instances
574: WHERE target_chr_id = p_target_id
575: AND cop_id = G_RENCON_CLASS_OPERATION_ID; -- Bug#5981381: Use cached class_operation_id
576: /*(SELECT ID FROM OKC_CLASS_OPERATIONS
577: WHERE OPN_CODE = 'REN_CON' AND CLS_CODE = 'SERVICE');
578: */
579:
580: --------------------------------------------------------------------

Line 816: SELECT ID FROM OKC_CLASS_OPERATIONS

812: -------------------------------------------------------------------------
813: ---Find the Class Operation ID to be used
814: --------------------------------------------------------------------------
815: CURSOR class_operations IS
816: SELECT ID FROM OKC_CLASS_OPERATIONS
817: WHERE OPN_CODE = 'REN_CON' AND CLS_CODE = 'SERVICE';
818:
819: BEGIN
820: -- Bug#5981381: Use cached class_operation_id