APPS.PAY_US_MMREF_REPORTING_MT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 154: FROM hr_all_organization_units hou,

150: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
151: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
152: 'TAX_UNIT_NAME=P' , hou.name,
153: 'TRANSFER_EMP_CODE=P', 'R'
154: FROM hr_all_organization_units hou,
155: pay_payroll_actions ppa,
156: pay_assignment_actions AA
157: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
158: ('TRANSFER_PAYROLL_ACTION_ID')

Line 178: FROM hr_all_organization_units hou,

174: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
175: 'TAX_UNIT_NAME=P' , hou.name,
176: 'TRANSFER_EMP_CODE=P', 'R',
177: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
178: FROM hr_all_organization_units hou,
179: pay_payroll_actions ppa,
180: pay_assignment_actions AA
181: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
182: ('TRANSFER_PAYROLL_ACTION_ID')

Line 203: FROM hr_all_organization_units hou,

199: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
200: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
201: 'TAX_UNIT_NAME=P', hou.name,
202: 'TRANSFER_EMP_CODE=P' , 'R'
203: FROM hr_all_organization_units hou,
204: pay_payroll_actions ppa,
205: pay_assignment_actions AA
206: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')

Line 225: FROM hr_all_organization_units hou,

221: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
222: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
223: 'TAX_UNIT_NAME=P', hou.name,
224: 'TRANSFER_EMP_CODE=P' , 'Q'
225: FROM hr_all_organization_units hou,
226: pay_payroll_actions ppa,
227: pay_assignment_actions AA
228: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
229: ('TRANSFER_PAYROLL_ACTION_ID')