APPS.PQP_GB_PSI_SALARY_HISTORY SQL Statements

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

Line: 445

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

Line: 541

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

Line: 621

            select PPS.DATE_START --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 g_effective_date
                between per.effective_start_date
                        and NVL(per.effective_end_date,c_highest_date)
              and g_effective_date
                between pps.date_start
                        and NVL(pps.last_standard_process_date,c_highest_date);

Line: 903

            /*l_query := 'select '||g_assignment_column||' '||'
                         from per_all_assignments_f '||
                         'where business_group_id = '||g_business_group_id||' '||
                         'and assignment_id = '||g_assignment_id||' '||
                         'and ASS_ATTRIBUTE_CATEGORY = '||''''||g_assignment_context||''''||
                         'and to_date('||''''||TO_CHAR(p_effective_date,'dd/mm/yyyy')||''''||
                         ',''dd/mm/yyyy'')'||' between effective_start_date
                                                    and effective_end_date';*/

Line: 912

            l_query :=   'select '||g_assignment_column||' '||
                         'from per_all_assignments_f '||' '||
                         'where business_group_id = '||g_business_group_id||' '||
                         'and assignment_id = '||g_assignment_id||' ';

Line: 1069

            l_chg_type            :=  g_pay_proc_evt_tab(l_index).update_type;

Line: 1091

                   debug('For update type pick the value from new_value',40);