DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on FND_LOOKUP_VALUES

Line 211: fnd_lookup_values lv

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
215: AND le_node.business_group_id = p_business_group_id

Line 1360: fnd_lookup_values flv

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
1364: AND le_node.node_type = 'MX LEGAL EMPLOYER'

Line 1443: fnd_lookup_values flv

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
1447: AND le_node.node_type = 'MX LEGAL EMPLOYER'