APPS.PAY_US_FLS_REPORTING_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 215: from hr_organization_information hoi

211: RETURN NUMBER IS
212:
213: cursor c_get_fein (cp_tax_unit_id in number) is
214: select replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
215: from hr_organization_information hoi
216: where hoi.organization_id = cp_tax_unit_id
217: and hoi.org_information_context = 'Employer Identification';
218:
219: cursor c_get_gre_name (cp_tax_unit_id in number) is

Line 270: from hr_organization_information hoi

266: ,cp_end_date in date
267: ) is
268: select organization_id,
269: replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
270: from hr_organization_information hoi
271: where org_information_context = 'Employer Identification'
272: and exists (select 'x'
273: from pay_assignment_actions paa,
274: pay_payroll_actions ppa