DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_US_STATES

Line 381: from pay_us_states pus,

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