APPS.PAY_MX_YREND_ARCH dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 210: per_gen_hierarchy_versions hier_ver,

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'
214: AND le_node.entity_id = p_le_id

Line 1359: per_gen_hierarchy_versions hier_ver,

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
1363: AND gre_exists (gre_node.entity_id) = 1

Line 1442: per_gen_hierarchy_versions hier_ver,

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
1446: AND gre_exists (gre_node.entity_id) = 1