APPS.PAY_NO_TC_REQ SQL Statements

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

Line: 12

SELECT legislative_parameters
FROM   pay_payroll_actions
WHERE  payroll_action_id = p_pact_id;

Line: 71

    p_sqlstr := 'SELECT DISTINCT person_id
                FROM   per_all_people_f    ppf,
                       pay_payroll_actions ppa
                WHERE  ppa.payroll_action_id = :payroll_action_id
                  AND  ppa.business_group_id = ppf.business_group_id
             ORDER BY  ppf.person_id';