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'