APPS.PAY_EOSURVEY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1708: from hr_organization_information hoi,

1704:
1705: cursor fein_par(c_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)
1706: is
1707: select hoi.org_information3 fein
1708: from hr_organization_information hoi,
1709: per_gen_hierarchy_nodes pghn
1710: where hoi.organization_id = pghn.entity_id
1711: and pghn.node_type = 'PAR'
1712: and pghn.hierarchy_version_id = c_version_id

Line 1730: l_par_gre hr_organization_information.org_information3%type;

1726:
1727: l_address varchar2(1000);
1728: l_est_gre hr_location_extra_info.lei_information1%type;
1729: l_est_name hr_location_extra_info.lei_information1%type;
1730: l_par_gre hr_organization_information.org_information3%type;
1731:
1732: begin
1733: hr_utility.trace('=============================== gre_name==================================');
1734: OPEN fein_est(p_entity_id);