APPS.CSM_EMAIL_QUERY_PKG dependencies on CSM_QUERY_B

Line 359: FROM CSM_QUERY_B

355: RESTRICTED_FLAG,
356: DISABLED_FLAG,
357: LEVEL_ID,
358: LEVEL_VALUE
359: FROM CSM_QUERY_B
360: WHERE UPPER(QUERY_NAME) = p_command_name
361: AND NVL(DELETE_FLAG,'N') = 'N';
362:
363: CURSOR c_get_all_vars (p_query_id NUMBER)

Line 2025: csm_query_b qb

2021:
2022: l_query_text := 'SELECT query_name command_name,
2023: description
2024: FROM csm_query_tl qtl,
2025: csm_query_b qb
2026: WHERE UPPER(qb.query_name) like UPPER(''%'|| trim(p_query_name) ||'%'')
2027: AND qb.email_enabled = ''Y''
2028: AND NVL(qb.disabled_flag,''N'') = ''N''
2029: AND qtl.language = userenv(''LANG'')