APPS.CSM_QUERY_INSTANCE_PKG dependencies on CSM_QUERY_VARIABLE_VALUES_INQ

Line 25: FROM CSM_QUERY_VARIABLE_VALUES_INQ

21: AND ((b.EXECUTION_MODE = 'SYNCHRONOUS' AND b_from_sync ='Y') OR b_from_sync = 'N');
22:
23: CURSOR c_query_variable_values( b_user_name VARCHAR2, b_tranid NUMBER, b_instance_id NUMBER) is
24: SELECT *
25: FROM CSM_QUERY_VARIABLE_VALUES_INQ
26: WHERE tranid$$ = b_tranid
27: AND clid$$cs = b_user_name
28: AND INSTANCE_ID = b_instance_id;
29: /***

Line 61: FROM CSM_QUERY_VARIABLE_VALUES_INQ vb

57: SELECT vb.VARIABLE_ID,
58: vb.VARIABLE_VALUE_CHAR,
59: vb.VARIABLE_VALUE_DATE,
60: vb.SEQNO$$
61: FROM CSM_QUERY_VARIABLE_VALUES_INQ vb
62: WHERE vb.CLID$$CS = c_user_name
63: AND vb.TRANID$$ = c_tran_id
64: AND vb.QUERY_ID = c_QUERY_ID
65: AND vb.INSTANCE_ID = c_instance_id;