eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_PSD_XML dependencies on HR_ORGANIZATION_INFORMATION

Line 103: hr_organization_information hoi,

99: 'BUSINESS_GROUP_ID=P', ppa.business_group_id,
100: 'TRANSFER_STATE_CODE=P', substr (sr.jurisdiction_code, 1 , 2),
101: 'ROOT_XML_TAG=P', ''
102: FROM pay_state_rules sr,
103: hr_organization_information hoi,
104: pay_payroll_actions ppa
105: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID')
106: AND ppa.report_qualifier = 'LOCAL'
107: AND hoi.organization_id = pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID')

Line 126: hr_organization_information hoi

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
128: ('TRANSFER_PAYROLL_ACTION_ID')
129: AND ppa.report_type = 'PSD_MAG_XML'
130: AND to_char(ppa.effective_date, 'YYYY') =

Line 147: hr_organization_information hoi,

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,
149: pay_us_asg_reporting puar
150: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')

Line 177: hr_organization_information hoi,

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,
178: pay_us_asg_reporting puar
179: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
180: ('TRANSFER_PAYROLL_ACTION_ID')
181: AND ppa.report_type = 'PSD_MAG_XML'

Line 206: hr_organization_information hoi,

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,
207: pay_us_asg_reporting puar
208: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
209: ('TRANSFER_PAYROLL_ACTION_ID')
210: AND ppa.report_type = 'YREND'