APPS.PQP_GB_PSI_STH_HISTORY SQL Statements

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

Line: 136

              SELECT element_set_id
              FROM pay_event_group_usages pegu
                  ,pay_event_groups peg
              WHERE peg.event_group_name = 'PQP_GB_PSI_STH_ELEMENT_ENTRIES'
              AND peg.legislation_code = 'GB'
              AND peg.business_group_id IS NULL
              AND peg.event_group_id = pegu.event_group_id;

Line: 149

            SELECT  pet.element_type_id
                    ,pet.element_name
                    ,pet.processing_type
                    ,piv.input_value_id
                    ,piv.name
                    ,piv.uom
                    ,piv.unit_of_measure
            FROM pay_element_set_members pes
                ,pay_input_values_v piv
                ,pay_element_types_f pet
            WHERE pes.element_set_id = p_element_set_id
            AND pes.element_type_id = pet.element_type_id
            AND pet.element_type_id = piv.element_type_id (+)
            ORDER BY ELEMENT_NAME;

Line: 296

            SELECT  pet.element_type_id
                    ,pet.element_name
                    ,pet.processing_type
                    ,piv.name
                    ,piv.uom
                    ,piv.unit_of_measure
            FROM pay_event_groups peg
                ,pay_event_group_usages pegu
                ,pay_element_set_members pes
                ,pay_input_values_v piv
                ,pay_element_types_f pet
            WHERE peg.event_group_name = 'PQP_GB_PSI_STH_ELEMENT_ENTRIES'
            AND peg.event_group_id = pegu.event_group_id
            AND pegu.element_set_id = pes.element_set_id
            AND pes.element_type_id = pet.element_type_id
            AND pet.element_type_id = piv.element_type_id (+)
            ORDER BY ELEMENT_NAME;*/

Line: 321

        g_valid_element_type_details.DELETE;

Line: 672

            SELECT effective_start_date,
                  effective_end_date
            FROM PAY_ELEMENT_ENTRIES_F
            WHERE element_entry_id = g_curr_element_entry_id;

Line: 746

        g_valid_element_type_details.DELETE;

Line: 791

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

        g_proc_ele_entries.DELETE;

Line: 812

        g_reported_claim_dates.DELETE;

Line: 813

        g_reported_pay_periods.DELETE;

Line: 913

          SELECT value
          FROM PER_ASSIGNMENT_BUDGET_VALUES_F
          WHERE assignment_id = g_assignment_id
          AND UNIT = 'FTE'
          AND p_claim_date between effective_start_date
                          AND effective_end_date;

Line: 991

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

Line: 1006

            SELECT peef.element_type_id
                   ,pet.element_name
            FROM pay_element_entries_f peef
                 ,pay_element_types_f pet
            WHERE peef.element_entry_id = p_element_entry_id
            AND pet.element_type_id = peef.element_type_id;

Line: 1018

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

Line: 1026

        l_chg_type          :=  ben_ext_person.g_chg_update_type;

Line: 1371

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