DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 403: from hr_all_organization_units hou,

399: union
400: select /*+ INDEX (pac PAY_PAYROLL_ACTIONS_PK) */
401: 'Federal-'||pac.report_type||decode(hou.name,
402: NULL, NULL, '-'||hou.name)
403: from hr_all_organization_units hou,
404: pay_payroll_actions pac
405: where pac.payroll_action_id = p_payroll_action_id
406: and pac.report_category is not null
407: and pac.report_qualifier = 'FED'