APPS.PAY_MX_SS_ARCH_TRAN_DATE_UPG SQL Statements

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

Line: 67

        SELECT 'Y'
          FROM pay_payroll_actions ppa,
               pay_assignment_actions paa,
               pay_action_information pai
         WHERE ppa.payroll_action_id = paa.payroll_action_id
           AND paa.assignment_action_id = pai.action_context_id
           AND pai.action_information_category = 'MX SS TRANSACTIONS'
           AND paa.assignment_id = p_object_id
           AND ppa.report_type = 'SS_ARCHIVE'
           AND ppa.report_qualifier = 'SS_ARCHIVE'
           AND ppa.report_category = 'RT';

Line: 109

        SELECT pai.action_information2,
               pai.action_information5,
               pai.action_information_id,
               pai.object_version_number
          FROM pay_payroll_actions ppa,
               pay_assignment_actions paa,
               pay_action_information pai
         WHERE ppa.payroll_action_id = paa.payroll_action_id
           AND paa.assignment_action_id = pai.action_context_id
           AND pai.action_information_category = 'MX SS TRANSACTIONS'
           AND paa.assignment_id = p_object_id
           AND ppa.report_type = 'SS_ARCHIVE'
           AND ppa.report_qualifier = 'SS_ARCHIVE'
           AND ppa.report_category = 'RT';

Line: 145

            pay_action_information_api.update_action_information
               (p_action_information_id   => ln_act_info_id,
                p_object_version_number   => l_object_version_number,
                p_action_information2     => lv_transaction_date,
                p_action_information5     => lv_er_ss_id);