APPS.PAY_FR_REBATES SQL Statements

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

Line: 16

  select effective_date
  into   l_effective_date
  from   fnd_sessions
  where  session_id = userenv('SESSIONID');

Line: 441

     select 'X'
     from hr_organization_information hoi
     where (
            (
             p_date_from between fnd_date.canonical_to_date(hoi.org_information1)
                             and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
                                                          ,fnd_date.canonical_to_date(hoi.org_information2))
            )
            or
            (
             l_end_date between fnd_date.canonical_to_date(hoi.org_information1)
                            and decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
                                                          ,fnd_date.canonical_to_date(hoi.org_information2))
            )
            or
            (
             l_end_date >= decode(p_information_type,'FR_ESTAB_ROBIEN',add_months(fnd_date.canonical_to_date(hoi.org_information1),60)
                                                            ,fnd_date.canonical_to_date(hoi.org_information2))
             and p_date_from <= fnd_date.canonical_to_date(hoi.org_information1)
            )
           )
     and hoi.org_information_context = decode(p_information_type,'FR_ESTAB_ROBIEN',
                                              'FR_ESTAB_AUBRY_I','FR_ESTAB_ROBIEN')
     and hoi.organization_id = p_org_id;

Line: 682

    select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
                                          paa.assignment_action_id),16))
    from   pay_assignment_actions paa,
           pay_payroll_actions    ppa
    where  paa.assignment_id = p_assignment_id
    and    ppa.payroll_action_id = paa.payroll_action_id
    and    ppa.effective_date between
                                  pay_fr_general.g_prev_start_date and
                                  pay_fr_general.g_prev_end_date
    and    ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line: 694

    select creator_id
    from   ff_user_entities
    where  user_entity_name = p_balance_name;