DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on FND_LOOKUP_VALUES

Line 370: fnd_lookup_values lv

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 */
374: AND le_node.business_group_id = p_business_group_id

Line 1599: fnd_lookup_values flv

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

Line 1689: fnd_lookup_values flv

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