APPS.CSM_PROFILE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

SELECT responsibility_id,app_id
FROM   asg_user
WHERE  user_id = c_user_id;

Line: 77

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CS_INV_VALIDATION_ORG';

Line: 106

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CS_INV_VALIDATION_ORG';

Line: 136

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_ITEM_CATEGORY_SET_FILTER';

Line: 166

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_ITEM_CATEGORY_FILTER';

Line: 196

SELECT NVL(acc.profile_option_value,0)
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_HISTORY_COUNT';

Line: 242

  SELECT val.profile_option_value
    FROM fnd_profile_options       opt,
         fnd_profile_option_values val
    WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
     AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
     AND opt.profile_option_name = p_profile_option_name
     AND opt.application_id      = val.application_id
     AND opt.profile_option_id   = val.profile_option_id
     AND ( ( val.level_id    = G_RESP_LEVEL_ID    AND
             val.level_value = p_resp_level_value
           ) OR
           ( val.level_id    = G_USER_LEVEL_ID    AND
             val.level_value = p_user_level_value
           )
         )
         ORDER BY val.level_id DESC;

Line: 298

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSF_M_CHANGE_COMPLETED_TASKS';

Line: 326

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSF_M_SHOW_NEW_MAIL_ONLY';

Line: 375

SELECT acc.profile_option_value
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_MAX_ATTACHMENT_SIZE';

Line: 405

SELECT NVL(acc.profile_option_value,0)
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_IB_ITEMS_AT_LOCATION';

Line: 440

SELECT NVL(acc.profile_option_value,3) -- download just 3 readings if profile is not set
FROM csm_profile_option_values_acc acc,
     fnd_profile_options po
WHERE acc.user_id = p_user_id
AND acc.profile_option_id = po.profile_option_id
AND po.profile_option_name = 'CSM_MAX_READINGS_PER_COUNTER';

Line: 500

SELECT val.PROFILE_OPTION_VALUE
FROM   FND_PROFILE_OPTION_VALUES val,
       FND_PROFILE_OPTIONS prf
WHERE  prf.PROFILE_OPTION_ID   =  val.PROFILE_OPTION_ID
AND    prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
AND    LEVEL_ID    = 10003
AND    LEVEL_VALUE = c_resp_id;

Line: 510

SELECT val.PROFILE_OPTION_VALUE
FROM   FND_PROFILE_OPTION_VALUES val,
       FND_PROFILE_OPTIONS prf
WHERE  prf.PROFILE_OPTION_ID   =  val.PROFILE_OPTION_ID
AND    prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
AND    LEVEL_ID    = 10001
AND    LEVEL_VALUE = 0;

Line: 552

  SELECT resp.APPLICATION_ID, resp.RESPONSIBILITY_ID
  FROM FND_RESPONSIBILITY resp, fnd_application app
  WHERE resp.RESPONSIBILITY_KEY = 'OMFS_PALM'
  AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
  AND app.application_id = resp.application_id
  AND app.application_short_name = 'CSM';