APPS.PAY_EXA_FLEX SQL Statements

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

Line: 43

    select null
    from   hr_lookups
    where  lookup_type = 'GB_BANKS'
    and    lookup_code = p_segment1;

Line: 523

  select null
  from hr_lookups
  where LOOKUP_TYPE = 'GB_COUNTRY'
  and   lookup_code = p_segment8;

Line: 742

    select null
    from   fnd_common_lookups
    where  lookup_type = 'US_ACCOUNT_TYPE'
    and    application_id = 800
    and    lookup_code = p_segment2;

Line: 1146

    select  pbg.legislation_code
    from    pay_legislation_rules plr,
            per_business_groups   pbg
    where   plr.rule_type         = 'E'
    and     plr.legislation_code  = pbg.legislation_code
    and     pbg.business_group_id = p_business_group_id
    and     plr.rule_mode         = to_char(p_rec.id_flex_num);