APPS.PAY_MX_YREND_ARCH dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 369: per_gen_hierarchy_versions hier_ver,

365: CURSOR csr_get_gres IS
366: SELECT gre_node.entity_id
367: FROM per_gen_hierarchy_nodes gre_node,
368: per_gen_hierarchy_nodes le_node,
369: per_gen_hierarchy_versions hier_ver,
370: fnd_lookup_values lv
371: WHERE gre_node.node_type = 'MX GRE'
372: AND le_node.node_type = 'MX LEGAL EMPLOYER'
373: AND le_node.entity_id = to_char(p_le_id) /* bug 11677462 */

Line 1598: per_gen_hierarchy_versions hier_ver,

1594: and ppa.payroll_action_id = paa.payroll_action_id
1595: and paa.tax_unit_id in (SELECT DISTINCT gre_node.entity_id
1596: FROM per_gen_hierarchy_nodes gre_node,
1597: per_gen_hierarchy_nodes le_node,
1598: per_gen_hierarchy_versions hier_ver,
1599: fnd_lookup_values flv
1600: WHERE gre_node.node_type = 'MX GRE'
1601: AND gre_node.business_group_id = paf.business_group_id
1602: AND gre_exists (gre_node.entity_id) = 1

Line 1688: per_gen_hierarchy_versions hier_ver,

1684: SELECT DISTINCT le_node.entity_id,
1685: gre_node.entity_id
1686: FROM per_gen_hierarchy_nodes gre_node,
1687: per_gen_hierarchy_nodes le_node,
1688: per_gen_hierarchy_versions hier_ver,
1689: fnd_lookup_values flv
1690: WHERE gre_node.node_type = 'MX GRE'
1691: AND gre_node.business_group_id = cp_business_group_id
1692: AND gre_exists (gre_node.entity_id) = 1