APPS.CS_KB_PROFILES_PKG SQL Statements

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

Line: 14

	select 1
	into x_temp
	from JTF_PERZ_PROFILE profile,
	     JTF_PERZ_DATA data,
	     JTF_PERZ_DATA_ATTRIB attrib
	where profile.profile_name = x_profile_name
	and   profile.profile_id = data.profile_id
	and   data.application_id = 170
	and   data.perz_data_name = 'CS_KB_WF_CATEGORY'
	and   data.perz_data_id = attrib.perz_data_id
	and   attrib.attribute_name = to_char(m_category_id);

Line: 45

        select 1
	    into x_temp
        from JTF_PERZ_PROFILE profile,
             JTF_PERZ_DATA data,
             JTF_PERZ_DATA_ATTRIB attrib
        where profile.profile_name = x_profile_name
        and   profile.profile_id = data.profile_id
        and   data.application_id = 170
        and   data.perz_data_name = 'CS_KB_WF_PRODUCT'
        and   data.perz_data_id = attrib.perz_data_id
        and   attrib.attribute_name = to_char(m_product_id)
        and   decode(substr(attrib.attribute_value,1,4),
             'org_', to_number(replace(attrib.attribute_value, 'org_','')) ,
             cs_std.get_item_valdn_orgzn_id) = m_product_org_id;