DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on HR_ALL_ORGANIZATION_UNITS

Line 211: FROM hr_all_organization_units hou,

207: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
208: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
209: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
210: 'TRANSFER_EMP_CODE=P', 'R'
211: FROM hr_all_organization_units hou,
212: pay_payroll_actions ppa,
213: pay_assignment_actions AA
214: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
215: ('TRANSFER_PAYROLL_ACTION_ID')

Line 236: FROM hr_all_organization_units hou,

232: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
233: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
234: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
235: 'TRANSFER_EMP_CODE=P' , 'R'
236: FROM hr_all_organization_units hou,
237: pay_payroll_actions ppa,
238: pay_assignment_actions AA
239: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
240: ('TRANSFER_PAYROLL_ACTION_ID')

Line 258: FROM hr_all_organization_units hou,

254: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
255: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
256: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
257: 'TRANSFER_EMP_CODE=P' , 'Q'
258: FROM hr_all_organization_units hou,
259: pay_payroll_actions ppa,
260: pay_assignment_actions AA
261: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
262: ('TRANSFER_PAYROLL_ACTION_ID')