APPS.PAY_EOSURVEY_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 1690: from hr_location_extra_info hlei

1686:
1687: cursor fein_est (c_entity_id per_gen_hierarchy_nodes.entity_id%type)
1688: is
1689: select hlei.lei_information6 fein
1690: from hr_location_extra_info hlei
1691: where hlei.location_id = c_entity_id
1692: and hlei.information_type = 'Establishment Information';
1693:
1694: cursor est_rpt_name(c_entity_id per_gen_hierarchy_nodes.entity_id%type)

Line 1697: from hr_location_extra_info

1693:
1694: cursor est_rpt_name(c_entity_id per_gen_hierarchy_nodes.entity_id%type)
1695: is
1696: SELECT lei_information1 rpt_name
1697: from hr_location_extra_info
1698: where location_id = c_entity_id
1699: and information_type = 'EEO-1 Specific Information';
1700:
1701:

Line 1728: l_est_gre hr_location_extra_info.lei_information1%type;

1724: from hr_locations
1725: where location_id = c_entity_id;
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

Line 1729: l_est_name hr_location_extra_info.lei_information1%type;

1725: where location_id = c_entity_id;
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==================================');