APPS.HR_TIPS_API SQL Statements

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

Line: 11

select PRODUCT_VERSION
from FND_PRODUCT_INSTALLATIONS
where APPLICATION_ID = p_application_id;

Line: 48

select t.text
  from hr_tips t
 where t.screen        = l_screen
   and t.field         = l_field
   and t.language_code = l_lang_code
   and t.business_group_id    = p_bg;

Line: 56

select t.text
  from hr_tips t
 where t.screen        = l_screen
   and t.field         = l_field
   and t.language_code = l_lang_code
   and t.business_group_id is null;

Line: 120

select t.field, t.text
  from hr_tips t
 where t.screen        = l_screen
   and t.language_code = l_lang_code
   and t.business_group_id    = p_bg
   and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS');

Line: 128

select t.field, t.text
  from hr_tips t
 where t.screen        = l_screen
   and t.language_code = l_lang_code
   and t.field NOT IN ('DISCLAIMER', 'INSTRUCTIONS')
   and ((t.business_group_id is null and not exists (select 'Y'
                                    from hr_tips
                                   where screen        = l_screen
                                    and language_code = l_lang_code
                                    and business_group_id    = p_bg
                                    and field = t.field))
   or t.business_group_id = p_bg);

Line: 192

  select t.text
    from hr_tips t
   where t.screen        = l_screen
     and t.field         = l_instruction_name
     and t.language_code = l_lang_code
     and (NVL(t.business_group_id,-1) = NVL(p_business_group_id,-1)
         OR NVL(t.business_group_id,-1) = NVL(p_default_bg,-1))
     order by t.business_group_id;

Line: 251

  select t.text
    from hr_tips t
   where t.screen        = l_screen
     and t.field         = 'DISCLAIMER'
     and t.language_code = l_lang_code
     and (NVL(t.business_group_id,0) = NVL(p_business_group_id,0)
          OR NVL(t.business_group_id,0) = NVL(p_default_bg,0));