DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_US_STATES

Line 380: from pay_us_states pus,

376: cursor get_archiver is
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