APPS.PAY_JP_ITW_REPORT_ARCHIVE SQL Statements

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

Line: 187

        select COUNT(1)
        into   l_count
        from   pay_payroll_actions    ppa,
               pay_assignment_actions paa
        where  ppa.request_id = l_request_id
        and    ppa.action_type = 'X'
        and    paa.payroll_action_id = ppa.payroll_action_id
        and    paa.action_status <> 'C';