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_EOSY_AC_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 58: per_gen_hierarchy_nodes pghn,

54:
55: sqlstr:=
56: 'select distinct paf.person_id
57: from pay_payroll_actions ppa, -- pyugen
58: per_gen_hierarchy_nodes pghn,
59: per_assignments_f paf,
60: per_assignment_status_types past,
61: per_jobs pj,
62: fnd_common_lookups fcl

Line 75: FROM per_gen_hierarchy_nodes

71: )
72: OR
73: (
74: parent_hierarchy_node_id in(SELECT hierarchy_node_id
75: FROM per_gen_hierarchy_nodes
76: WHERE hierarchy_version_id =pay_eosy_ac_pkg.get_parameter
77: (''HI_VER_ID'',ppa.legislative_parameters)
78: AND entity_id = nvl(pay_eosy_ac_pkg.get_parameter
79: (''EST_ID'',ppa.legislative_parameters),entity_id)

Line 138: per_gen_hierarchy_nodes pghn,

134: FROM pay_assignment_actions paa,
135: pay_payroll_actions ppa,
136: per_assignments_f paf,
137: per_jobs pj,
138: per_gen_hierarchy_nodes pghn,
139: -- per_assignment_status_types past, -- BUG3886008
140: fnd_common_lookups fcl
141: WHERE ppa.effective_date between l_start_date and l_end_date
142:

Line 180: from per_gen_hierarchy_nodes pghn2

176: OR
177: (
178: pghn.parent_hierarchy_node_id
179: in(select pghn2.hierarchy_node_id
180: from per_gen_hierarchy_nodes pghn2
181: where pghn2.hierarchy_version_id =l_version_id
182: and pghn2.entity_id = nvl(l_est_id,pghn2.entity_id)
183: and pghn2.node_type = 'EST')
184: AND pghn.node_type = 'LOC'