378: select /*+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) */
379: pus.state_name||'-'||pac.report_type||decode(hou.name,
380: NULL, NULL, '-'||hou.name)
381: from pay_us_states pus,
382: hr_organization_units hou,
383: pay_payroll_actions pac,
384: per_business_groups_perf bg
385: where pac.payroll_action_id = p_payroll_action_id
386: and pac.report_qualifier = pus.state_abbrev