The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT responsibility_id,app_id
FROM asg_user
WHERE user_id = c_user_id;
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';
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';
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';
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';
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';
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;
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';
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';
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';
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';
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';