APPS.PAY_US_MMREF_REPORTING1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 192: FROM hr_all_organization_units hou,

188: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
189: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
190: 'TAX_UNIT_NAME=P' , hou.name,
191: 'TRANSFER_EMP_CODE=P', 'R'
192: FROM hr_all_organization_units hou,
193: pay_payroll_actions ppa,
194: pay_assignment_actions AA
195: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
196: ('TRANSFER_PAYROLL_ACTION_ID')

Line 216: FROM hr_all_organization_units hou,

212: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
213: 'TAX_UNIT_NAME=P' , hou.name,
214: 'TRANSFER_EMP_CODE=P', 'R',
215: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
216: FROM hr_all_organization_units hou,
217: pay_payroll_actions ppa,
218: pay_assignment_actions AA
219: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')

Line 241: FROM hr_all_organization_units hou,

237: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
238: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
239: 'TAX_UNIT_NAME=P', hou.name,
240: 'TRANSFER_EMP_CODE=P' , 'R'
241: FROM hr_all_organization_units hou,
242: pay_payroll_actions ppa,
243: pay_assignment_actions AA
244: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
245: ('TRANSFER_PAYROLL_ACTION_ID')

Line 263: FROM hr_all_organization_units hou,

259: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
260: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
261: 'TAX_UNIT_NAME=P', hou.name,
262: 'TRANSFER_EMP_CODE=P' , 'Q'
263: FROM hr_all_organization_units hou,
264: pay_payroll_actions ppa,
265: pay_assignment_actions AA
266: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
267: ('TRANSFER_PAYROLL_ACTION_ID')