DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on HR_ALL_ORGANIZATION_UNITS

Line 119: FROM hr_all_organization_units hou,

115: SELECT DISTINCT
116: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
117: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
118: 'TAX_UNIT_NAME=P', substr(hou.name,1,80) -- Bug# 14286448 Gre length issue
119: FROM hr_all_organization_units hou,
120: pay_payroll_actions ppa,
121: pay_assignment_actions aa
122: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
123: ('TRANSFER_PAYROLL_ACTION_ID')