APPS.PAY_US_MMREF_REPORTING_MT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 155: FROM hr_all_organization_units hou,

151: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
152: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
153: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
154: 'TRANSFER_EMP_CODE=P', 'R'
155: FROM hr_all_organization_units hou,
156: pay_payroll_actions ppa,
157: pay_assignment_actions AA
158: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
159: ('TRANSFER_PAYROLL_ACTION_ID')

Line 179: FROM hr_all_organization_units hou,

175: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
176: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
177: 'TRANSFER_EMP_CODE=P', 'R',
178: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
179: FROM hr_all_organization_units hou,
180: pay_payroll_actions ppa,
181: pay_assignment_actions AA
182: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_PAYROLL_ACTION_ID')

Line 204: FROM hr_all_organization_units hou,

200: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
201: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
202: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
203: 'TRANSFER_EMP_CODE=P' , 'R'
204: FROM hr_all_organization_units hou,
205: pay_payroll_actions ppa,
206: pay_assignment_actions AA
207: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
208: ('TRANSFER_PAYROLL_ACTION_ID')

Line 226: FROM hr_all_organization_units hou,

222: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
223: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
224: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
225: 'TRANSFER_EMP_CODE=P' , 'Q'
226: FROM hr_all_organization_units hou,
227: pay_payroll_actions ppa,
228: pay_assignment_actions AA
229: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
230: ('TRANSFER_PAYROLL_ACTION_ID')