DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 402: from hr_all_organization_units hou,

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