2 Replies Latest reply on Apr 3, 2014 10:14 AM by Vigneswar Battu

    Unprocessed Elements in Payroll

    ahmad

      Dears,

       

      May anyone please provide me with a query to view unprocessed element in element entry window for a specific payroll run period ?

        • 1. Re: Unprocessed Elements in Payroll
          ahmad

          I wrote it....

          Thanks.

          [code]

          SELECT :employee_number employee_number,

                 (SELECT full_name

                    FROM per_all_people_f

                   WHERE employee_number = :employee_number

                     AND SYSDATE BETWEEN effective_start_date AND effective_end_date)

                                                                          employee_name,

                 b.element_name, process_in_run_flag, c.effective_start_date

            FROM pay_element_entries_f a,

                 paybv_element_type b,

                 pay_element_entry_values_f c

          WHERE 1 = 1

             AND a.assignment_id =

                          (SELECT DISTINCT assignment_id

                                      FROM per_all_assignments_f

                                     WHERE person_id =

                                              (SELECT DISTINCT person_id

                                                          FROM per_people_f

                                                         WHERE employee_number =

                                                                        :employee_number))

             AND a.element_type_id = b.element_type_id

             AND c.element_entry_id = a.element_entry_id

             AND c.screen_entry_value IS NOT NULL

             AND process_in_run_flag = 'No'

             AND TO_CHAR (c.effective_start_date, 'MON-YYYY') = :p_period   --'FEB-2014'

          [/code]

          • 2. Re: Unprocessed Elements in Payroll
            Vigneswar Battu

            There is a view for it -

            PAY_PAYWSMEE_ELEMENT_ENTRIES