APPS.CSM_EMAIL_QUERY_PKG dependencies on CSM_QUERY_VARIABLES_B

Line 369: FROM CSM_QUERY_VARIABLES_B

365: SELECT variable_id,
366: variable_value_char,
367: variable_value_date,
368: default_flag
369: FROM CSM_QUERY_VARIABLES_B
370: WHERE QUERY_ID = p_query_id;
371:
372: CURSOR c_get_reqd_vars (p_query_id NUMBER)
373: IS

Line 375: FROM CSM_QUERY_VARIABLES_B

371:
372: CURSOR c_get_reqd_vars (p_query_id NUMBER)
373: IS
374: SELECT count(*)
375: FROM CSM_QUERY_VARIABLES_B
376: WHERE QUERY_ID = p_query_id
377: AND DEFAULT_FLAG = 'N';
378:
379: CURSOR c_get_appl_resp_id