APPS.HR_MX_UTILITY dependencies on FND_LOOKUP_VALUES

Line 445: fnd_lookup_values lv

441: INTO r_legal_employer_id
442: FROM per_gen_hierarchy_nodes gre_node,
443: per_gen_hierarchy_nodes le_node,
444: per_gen_hierarchy_versions hier_ver,
445: fnd_lookup_values lv
446: WHERE gre_node.node_type = 'MX GRE'
447: AND gre_node.entity_id = p_tax_unit_id
448: AND gre_node.business_group_id = p_business_group_id
449: AND gre_node.hierarchy_version_id = le_node.hierarchy_version_id

Line 1045: FROM fnd_lookup_values

1041: --------------------------------------------------------------------------
1042: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
1043: CURSOR csr_get_iana_charset IS
1044: SELECT tag
1045: FROM fnd_lookup_values
1046: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
1047: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
1048: INSTR(USERENV('LANGUAGE'), '.') + 1)
1049: AND language = 'US';

Line 1051: lv_iana_charset fnd_lookup_values.tag%type;

1047: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
1048: INSTR(USERENV('LANGUAGE'), '.') + 1)
1049: AND language = 'US';
1050:
1051: lv_iana_charset fnd_lookup_values.tag%type;
1052: BEGIN
1053: OPEN csr_get_iana_charset;
1054: FETCH csr_get_iana_charset INTO lv_iana_charset;
1055: CLOSE csr_get_iana_charset;