eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EOSURVEY_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 84: entity_id per_gen_hierarchy_nodes.entity_id%TYPE,

80: To store the establishment information and fein number this table is
81: declared globally. */
82:
83: TYPE establishment IS RECORD(
84: entity_id per_gen_hierarchy_nodes.entity_id%TYPE,
85: hierarchy_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE,
86: fein varchar2(100), -- BUG3894120
87: location_name varchar2(1000),
88: est_flag varchar2(1));

Line 85: hierarchy_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE,

81: declared globally. */
82:
83: TYPE establishment IS RECORD(
84: entity_id per_gen_hierarchy_nodes.entity_id%TYPE,
85: hierarchy_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE,
86: fein varchar2(100), -- BUG3894120
87: location_name varchar2(1000),
88: est_flag varchar2(1));
89: est_rec establishment;

Line 121: (l_est_id per_gen_hierarchy_nodes.entity_id%type,

117: hierarchy version id. If an establishment is given then it picks up the
118: locations under that establishment and including the entity_id of that est.*/
119:
120: CURSOR c_est_loc
121: (l_est_id per_gen_hierarchy_nodes.entity_id%type,
122: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%type)
123: IS
124: SELECT entity_id,parent_hierarchy_node_id
125: FROM per_gen_hierarchy_nodes

Line 125: FROM per_gen_hierarchy_nodes

121: (l_est_id per_gen_hierarchy_nodes.entity_id%type,
122: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%type)
123: IS
124: SELECT entity_id,parent_hierarchy_node_id
125: FROM per_gen_hierarchy_nodes
126: WHERE hierarchy_version_id = l_hierarchy_version_id
127: AND (
128: (
129: entity_id = nvl(l_est_id,entity_id)

Line 134: parent_hierarchy_node_id in(select hierarchy_node_id from per_gen_hierarchy_nodes

130: AND node_type ='EST'
131: )
132: OR
133: (
134: parent_hierarchy_node_id in(select hierarchy_node_id from per_gen_hierarchy_nodes
135: where hierarchy_version_id =l_hierarchy_version_id
136: and entity_id = nvl(l_est_id,entity_id)
137: and node_type = 'EST')
138: AND node_type = 'LOC'

Line 147: ( l_location_id per_gen_hierarchy_nodes.entity_id%type,

143: /* This cursor picks up the applicants and the terminated employees
144: from the given location.*/
145:
146: CURSOR c_app_term_assignments
147: ( l_location_id per_gen_hierarchy_nodes.entity_id%type,
148: l_period_end date,
149: l_period_start per_assignments_f.effective_start_date%type
150: )
151: IS

Line 649: CURSOR c_est_id(l_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type,

645:
646: /* This cursor picks up all the establishments for a given hierarchy_version_id.
647: If an establishment is specified then it picks up the infm for that est alone. */
648:
649: CURSOR c_est_id(l_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type,
650: l_entity_id per_gen_hierarchy_nodes.entity_id%type)
651: IS
652: SELECT entity_id,hierarchy_node_id
653: FROM per_gen_hierarchy_nodes

Line 650: l_entity_id per_gen_hierarchy_nodes.entity_id%type)

646: /* This cursor picks up all the establishments for a given hierarchy_version_id.
647: If an establishment is specified then it picks up the infm for that est alone. */
648:
649: CURSOR c_est_id(l_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type,
650: l_entity_id per_gen_hierarchy_nodes.entity_id%type)
651: IS
652: SELECT entity_id,hierarchy_node_id
653: FROM per_gen_hierarchy_nodes
654: WHERE node_type = 'EST'

Line 653: FROM per_gen_hierarchy_nodes

649: CURSOR c_est_id(l_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type,
650: l_entity_id per_gen_hierarchy_nodes.entity_id%type)
651: IS
652: SELECT entity_id,hierarchy_node_id
653: FROM per_gen_hierarchy_nodes
654: WHERE node_type = 'EST'
655: AND entity_id =nvl(l_entity_id,entity_id)
656: AND hierarchy_version_id = l_version_id;
657:

Line 1184: CURSOR c_loc_hierarchy_id (l_location_id per_gen_hierarchy_nodes.entity_id%type,

1180:
1181: /*This cursor selects the parent_hierarchy_node_id for the selected
1182: entity_id. */
1183:
1184: CURSOR c_loc_hierarchy_id (l_location_id per_gen_hierarchy_nodes.entity_id%type,
1185: l_hierarchy_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)
1186: IS
1187: SELECT parent_hierarchy_node_id
1188: FROM per_gen_hierarchy_nodes

Line 1185: l_hierarchy_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)

1181: /*This cursor selects the parent_hierarchy_node_id for the selected
1182: entity_id. */
1183:
1184: CURSOR c_loc_hierarchy_id (l_location_id per_gen_hierarchy_nodes.entity_id%type,
1185: l_hierarchy_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)
1186: IS
1187: SELECT parent_hierarchy_node_id
1188: FROM per_gen_hierarchy_nodes
1189: WHERE entity_id = l_location_id

Line 1188: FROM per_gen_hierarchy_nodes

1184: CURSOR c_loc_hierarchy_id (l_location_id per_gen_hierarchy_nodes.entity_id%type,
1185: l_hierarchy_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)
1186: IS
1187: SELECT parent_hierarchy_node_id
1188: FROM per_gen_hierarchy_nodes
1189: WHERE entity_id = l_location_id
1190: AND hierarchy_version_id = l_hierarchy_version_id;
1191:
1192: /*If the report is not run for the recently concluded calendar year

Line 1275: l_parent_hierarchy_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;

1271: calendar_period_start date;
1272: calendar_period_end date;
1273: calendar_next_period_start date;
1274: p_cal_period_start date;
1275: l_parent_hierarchy_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
1276: cal_monetary_comp number:=0;
1277: l_package varchar2(70);
1278: l_exists varchar2(1);
1279: l_race varchar2(20);

Line 1687: cursor fein_est (c_entity_id per_gen_hierarchy_nodes.entity_id%type)

1683: If the reporting name is not found for the establishment then
1684: Reporting name not specified is printed. */
1685:
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

Line 1694: cursor est_rpt_name(c_entity_id per_gen_hierarchy_nodes.entity_id%type)

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)
1695: is
1696: SELECT lei_information1 rpt_name
1697: from hr_location_extra_info
1698: where location_id = c_entity_id

Line 1705: cursor fein_par(c_version_id per_gen_hierarchy_nodes.hierarchy_version_id%type)

1701:
1702:
1703: /*This cursor finds the fein infm of the parent. */
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

Line 1709: per_gen_hierarchy_nodes pghn

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
1713: and hoi.org_information_context = 'VETS_EEO_Dup';

Line 1716: cursor est_name_address (c_entity_id per_gen_hierarchy_nodes.entity_id%type)

1712: and pghn.hierarchy_version_id = c_version_id
1713: and hoi.org_information_context = 'VETS_EEO_Dup';
1714:
1715:
1716: cursor est_name_address (c_entity_id per_gen_hierarchy_nodes.entity_id%type)
1717: is
1718: select rtrim(address_line_1)||' '||
1719: rtrim(address_line_2)||' '||
1720: rtrim(address_line_3)||' '||