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 = to_char(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 1057: FROM fnd_lookup_values

1053: --------------------------------------------------------------------------
1054: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
1055: CURSOR csr_get_iana_charset IS
1056: SELECT tag
1057: FROM fnd_lookup_values
1058: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
1059: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
1060: INSTR(USERENV('LANGUAGE'), '.') + 1)
1061: AND language = 'US';

Line 1063: lv_iana_charset fnd_lookup_values.tag%type;

1059: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
1060: INSTR(USERENV('LANGUAGE'), '.') + 1)
1061: AND language = 'US';
1062:
1063: lv_iana_charset fnd_lookup_values.tag%type;
1064: BEGIN
1065: OPEN csr_get_iana_charset;
1066: FETCH csr_get_iana_charset INTO lv_iana_charset;
1067: CLOSE csr_get_iana_charset;