DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on HR_ALL_ORGANIZATION_UNITS

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' , hou.name,
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 229: FROM hr_all_organization_units hou,

225: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
226: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
227: 'TAX_UNIT_NAME=P', hou.name,
228: 'TRANSFER_EMP_CODE=P' , 'R'
229: FROM hr_all_organization_units hou,
230: pay_payroll_actions ppa,
231: pay_assignment_actions AA
232: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
233: ('TRANSFER_PAYROLL_ACTION_ID')

Line 251: FROM hr_all_organization_units hou,

247: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
248: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
249: 'TAX_UNIT_NAME=P', hou.name,
250: 'TRANSFER_EMP_CODE=P' , 'Q'
251: FROM hr_all_organization_units hou,
252: pay_payroll_actions ppa,
253: pay_assignment_actions AA
254: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
255: ('TRANSFER_PAYROLL_ACTION_ID')