APPS.PAY_NEGBAL_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 156: hr_organization_information HOI,

152: FROM per_assignments_f ASG,
153: hr_organization_units HOU,
154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,
157: pay_us_asg_reporting puar,
158: pay_payroll_actions PPA
159: WHERE PPA.payroll_action_id = :payroll_action_id
160: AND SR.state_code = '''||l_state||'''

Line 169: select ''x'' from hr_organization_information hoi2

165: AND ASG.assignment_type = ''E''
166: AND ASG.effective_start_date <= PPA.effective_date
167: AND ASG.effective_end_date >= PPA.start_date
168: AND ((not exists (
169: select ''x'' from hr_organization_information hoi2
170: where HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
171: and HOI2.org_information2 is not null
172: and HOI2.organization_id = hou.organization_id))
173: or ( '''||l_state||''' = ''CA'')

Line 221: FROM hr_organization_information hoi,

217: asg.person_id person_id,
218: paa.tax_unit_id tax_unit_id,
219: ppa.effective_date effective_end_date,
220: sr.jurisdiction_code jurisdiction_code
221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,

Line 275: FROM hr_organization_information hoi2

271: -- for update of asg.assignment_id;
272:
273: CURSOR c_transmitter is
274: SELECT decode(l_state,'CA',null,hoi2.org_information2)
275: FROM hr_organization_information hoi2
276: WHERE hoi2.organization_id = greid
277: AND hoi2.org_information_context = '1099R Magnetic Report Rules';
278:
279: --