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

Line 208: FROM per_gen_hierarchy_nodes gre_node,

204: p_effective_date DATE) IS
205: --
206: CURSOR csr_get_gres IS
207: SELECT gre_node.entity_id
208: FROM per_gen_hierarchy_nodes gre_node,
209: per_gen_hierarchy_nodes le_node,
210: per_gen_hierarchy_versions hier_ver,
211: fnd_lookup_values lv
212: WHERE gre_node.node_type = 'MX GRE'

Line 209: per_gen_hierarchy_nodes le_node,

205: --
206: CURSOR csr_get_gres IS
207: SELECT gre_node.entity_id
208: FROM per_gen_hierarchy_nodes gre_node,
209: per_gen_hierarchy_nodes le_node,
210: per_gen_hierarchy_versions hier_ver,
211: fnd_lookup_values lv
212: WHERE gre_node.node_type = 'MX GRE'
213: AND le_node.node_type = 'MX LEGAL EMPLOYER'

Line 1357: FROM per_gen_hierarchy_nodes gre_node,

1353: and payroll_action_id = ppa.payroll_action_id) )
1354: and ppa.payroll_action_id = paa.payroll_action_id
1355: and paa.tax_unit_id in
1356: (SELECT DISTINCT gre_node.entity_id
1357: FROM per_gen_hierarchy_nodes gre_node,
1358: per_gen_hierarchy_nodes le_node,
1359: per_gen_hierarchy_versions hier_ver,
1360: fnd_lookup_values flv
1361: WHERE gre_node.node_type = 'MX GRE'

Line 1358: per_gen_hierarchy_nodes le_node,

1354: and ppa.payroll_action_id = paa.payroll_action_id
1355: and paa.tax_unit_id in
1356: (SELECT DISTINCT gre_node.entity_id
1357: FROM per_gen_hierarchy_nodes gre_node,
1358: per_gen_hierarchy_nodes le_node,
1359: per_gen_hierarchy_versions hier_ver,
1360: fnd_lookup_values flv
1361: WHERE gre_node.node_type = 'MX GRE'
1362: AND gre_node.business_group_id = paf.business_group_id

Line 1440: FROM per_gen_hierarchy_nodes gre_node,

1436: cp_effective_date DATE
1437: ) IS
1438: SELECT DISTINCT le_node.entity_id,
1439: gre_node.entity_id
1440: FROM per_gen_hierarchy_nodes gre_node,
1441: per_gen_hierarchy_nodes le_node,
1442: per_gen_hierarchy_versions hier_ver,
1443: fnd_lookup_values flv
1444: WHERE gre_node.node_type = 'MX GRE'

Line 1441: per_gen_hierarchy_nodes le_node,

1437: ) IS
1438: SELECT DISTINCT le_node.entity_id,
1439: gre_node.entity_id
1440: FROM per_gen_hierarchy_nodes gre_node,
1441: per_gen_hierarchy_nodes le_node,
1442: per_gen_hierarchy_versions hier_ver,
1443: fnd_lookup_values flv
1444: WHERE gre_node.node_type = 'MX GRE'
1445: AND gre_node.business_group_id = cp_business_group_id