APPS.PAY_US_PSD_XML dependencies on HR_ALL_ORGANIZATION_UNITS

Line 123: FROM hr_all_organization_units hou,

119: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
120: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
121: 'TAX_UNIT_NAME=P', hou.name,
122: 'ER_PSD_CODE=P' , substr(hoi.ORG_INFORMATION10,1,6)
123: FROM hr_all_organization_units hou,
124: pay_payroll_actions ppa,
125: pay_assignment_actions aa,
126: hr_organization_information hoi
127: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 144: FROM hr_all_organization_units hou,

140: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
141: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
142: 'TAX_UNIT_NAME=P', hou.name,
143: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
144: FROM hr_all_organization_units hou,
145: pay_payroll_actions ppa,
146: pay_assignment_actions aa,
147: hr_organization_information hoi,
148: per_all_assignments_f paf,

Line 173: FROM hr_all_organization_units hou,

169: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
170: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
171: 'TAX_UNIT_NAME=P', hou.name,
172: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
173: FROM hr_all_organization_units hou,
174: pay_payroll_actions ppa,
175: pay_assignment_actions aa,
176: per_all_assignments_f paf,--Added for the Bug 15944697
177: hr_organization_information hoi,

Line 202: FROM hr_all_organization_units hou,

198: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
199: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
200: 'TAX_UNIT_NAME=P', hou.name,
201: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
202: FROM hr_all_organization_units hou,
203: pay_payroll_actions ppa,
204: pay_assignment_actions aa,
205: per_all_assignments_f paf,--Added for the Bug 15944697
206: hr_organization_information hoi,