APPS.PAY_US_FLS_REPORTING_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 206: from hr_organization_information hoi

202: RETURN NUMBER IS
203:
204: cursor c_get_fein (cp_tax_unit_id in number) is
205: select replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
206: from hr_organization_information hoi
207: where hoi.organization_id = cp_tax_unit_id
208: and hoi.org_information_context = 'Employer Identification';
209:
210: cursor c_get_gre_name (cp_tax_unit_id in number) is

Line 261: from hr_organization_information hoi

257: ,cp_end_date in date
258: ) is
259: select organization_id,
260: replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
261: from hr_organization_information hoi
262: where org_information_context = 'Employer Identification'
263: and exists (select 'x'
264: from pay_assignment_actions paa,
265: pay_payroll_actions ppa