APPS.CSM_QUERY_INSTANCE_PKG dependencies on CSM_QUERY_B

Line 17: CSM_QUERY_B b

13: /* Select all inq records */
14: CURSOR c_query_instances( b_user_name VARCHAR2, b_tranid NUMBER, b_from_sync VARCHAR2) is
15: SELECT inq.*
16: FROM CSM_QUERY_INSTANCES_INQ inq,
17: CSM_QUERY_B b
18: WHERE inq.tranid$$ = b_tranid
19: AND inq.clid$$cs = b_user_name
20: AND inq.QUERY_ID = b.QUERY_ID
21: AND ((b.EXECUTION_MODE = 'SYNCHRONOUS' AND b_from_sync ='Y') OR b_from_sync = 'N');

Line 42: FROM CSM_QUERY_B

38:
39: CURSOR c_check_query(c_QUERY_ID NUMBER)
40: IS
41: SELECT QUERY_NAME,LEVEL_ID,LEVEL_VALUE, QUERY_TYPE
42: FROM CSM_QUERY_B
43: WHERE QUERY_ID =c_QUERY_ID
44: AND NVL(DELETE_FLAG,'N') = 'N';
45:
46: CURSOR c_get_variables (c_QUERY_ID NUMBER)