DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 381: hr_organization_units hou,

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