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: 485

      l_chg_column_name pay_event_updates.column_name%TYPE;

Line: 486

      l_update_type     pay_datetracked_events.update_type%TYPE;

Line: 491

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

Line: 502

       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: 595

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

Line: 606

        l_update_type       :=  g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 613

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

Line: 623

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

Line: 670

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

Line: 814

    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;