APPS.PQP_GB_PSI_ALLOWANCE_HISTORY SQL Statements

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

Line: 242

            select DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
            from per_all_people_f PER, per_periods_of_service PPS
            where per.person_id = g_person_id
              and pps.person_id = g_person_id
              and rownum=1
              order by per.effective_start_date;

Line: 308

          ELSIF l_prev_event_dtl_rec.update_type <>   g_prev_event_dtl_rec.update_type THEN
              l_flag  :=  'N';

Line: 484

      Select info.eei_information2
      From pay_element_entries_f ent,
           pay_element_type_extra_info info
      Where info.eei_information_category = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
        and info.element_type_id = ent.element_type_id
        and ent.element_entry_id = p_element_entry_id
   	and p_eve_eff_date BETWEEN ent.effective_start_date AND effective_end_date;

Line: 495

      Select element_type_id
      From   pay_element_entries_f
      Where  assignment_id = p_assignment_id
        and  effective_start_date = p_eve_eff_date+1;

Line: 504

      Select 'x'
      From   pay_element_type_rules elerule,
             pay_event_group_usages eveusg,
             pay_event_groups evegrp,
             pay_element_type_extra_info elextra
      Where  elerule.element_type_id = c_element_type_id
        and  elerule.element_set_id = eveusg.element_set_id
        and  eveusg.event_group_id = evegrp.event_group_id
        and  evegrp.event_group_name = 'PQP_GB_PSI_ALL_ELEMENT_ENTRIES'
        and  elextra.element_type_id = elerule.element_type_id
        and  elextra.eei_information_category = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
        and  elextra.eei_information2 = c_allow_code;

Line: 617

      l_chg_column_name pay_event_updates.column_name%TYPE;

Line: 618

      l_update_type     pay_datetracked_events.update_type%TYPE;

Line: 623

        Select max(effective_end_date)
        From PAY_ELEMENT_ENTRIES_F
        Where element_entry_id = c_element_entry_id;

Line: 634

       Select actual_termination_date
       From per_all_assignments_f asg, per_periods_of_service per
       Where asg.assignment_id = p_assignment_id
       And per.period_of_service_id = asg.period_of_service_id
       AND p_effective_date between asg.effective_start_date and asg.effective_end_date;

Line: 727

        debug('update_type       :'||g_pay_proc_evt_tab(l_curr_evt_index).update_type      ,20);

Line: 738

        l_update_type       :=  g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 745

            l_update_type = 'C') THEN
            l_return   :=  'N';

Line: 755

            AND l_update_type = 'E')
        THEN
             l_surrogate_key := g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key;

Line: 815

            AND l_update_type in ('U','C') --For bug 7229852: Added Correction event
            )
        THEN
              g_leaver_event := 'Y';

Line: 959

    select 1
    from pay_element_entries_f pee, pay_element_type_extra_info petei
    where pee.assignment_id = p_assignment_id
    and pee.element_type_id = petei.element_type_id
    and p_effective_date between pee.effective_start_date and pee.effective_end_date
    and pee.element_entry_id <> PQP_GB_PSI_FUNCTIONS.g_curr_element_entry_id
    and petei.information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
    and petei.eei_information2 = g_allowance_code
    and rownum=1;