APPS.PQP_GB_PSI_BON_HISTORY SQL Statements

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

Line: 217

            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 p_effective_date  between per.effective_start_date
                       and NVL(per.effective_end_date,hr_api.g_eot)
              and p_effective_date  between pps.date_start
                       and NVL(pps.final_process_date,hr_api.g_eot);

Line: 243

        g_proc_bon_codes.DELETE;

Line: 374

            SELECT element_entry_id
            FROM pay_element_entry_values_f
            WHERE element_entry_value_id = p_ele_entry_value_id
            AND ROWNUM = 1;

Line: 384

            l_chg_type          :=  ben_ext_person.g_chg_update_type;

Line: 786

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

Line: 933

               SELECT  peev.screen_entry_value
              FROM pay_element_entry_values_f peev
                  ,pay_input_values_f piv
              WHERE peev.element_entry_id = g_curr_element_entry_id
              AND peev.input_value_id = piv.input_value_id
              AND UPPER(piv.NAME) = 'CLAIM DATE'
              --AND peev.effective_start_date = p_effective_date
              ORDER BY piv.name;