APPS.MSCX_UI_UTILITIES SQL Statements

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

Line: 9

select responsibility_key  into l_resp_key
        from fnd_responsibility
        where responsibility_id=fnd_global.resp_id
              and application_id=724;

Line: 21

select user_name  into l_user_name
        from fnd_user
        where user_id=grantee_key;

Line: 33

select responsibility_name  into l_resp_name
        from fnd_responsibility_vl
        where responsibility_id=grantee_key;

Line: 43

select group_name  into l_group_name
        from msc_groups
        where group_id=grantee_key;

Line: 53

select company_name  into l_company_name
        from msc_companies
        where company_id=grantee_key;

Line: 64

select distinct(company_site_name)  into l_site_name
        from msc_company_sites
        where company_site_id=p_site_id;

Line: 74

select item_name  into l_item_name
        from msc_items
        where inventory_item_id=p_item_id;

Line: 88

select meaning  into l_meaning
        from fnd_lookup_values
        where lookup_type='MSC_X_ORDER_TYPE'
	and language=userenv('lang')
	and lookup_code=to_char(p_order_type);

Line: 102

select meaning  into l_meaning
        from fnd_lookup_values
        where lookup_type='MSC_X_GRANTEE_TYPE'
	and language=userenv('lang')
	and lookup_code=p_grantee_type;

Line: 114

select meaning  into l_meaning
        from fnd_lookup_values
        where lookup_type='MSC_X_PRIVILEGE_TYPE'
	and language=userenv('lang')
	and lookup_code=p_privilege;