13:
14: Name : hr_lookups_util_pkg
15:
16: Description : Contains packages that allows quick retreival of
17: data that is created in PAY_LEGISLATIVE_FIELD_INFO
18: to map local lookups to Global Lookups.
19:
20: Format of the mapping in this table is as follows:
21:
60: --
61: hr_utility.set_location('Entering get_legisative_lookup_code', 10);
62: --
63: select field_name into l_localized_lookup_code
64: from pay_legislative_field_info
65: where rule_type = 'LOCAL_LOOKUP'
66: and legislation_code = p_legislation_code
67: and validation_name = p_lookup_code
68: and validation_type = p_lookup_type;
104: --
105: hr_utility.set_location('Entering get_global_lookup_code', 10);
106: --
107: select validation_name into l_global_lookup_code
108: from pay_legislative_field_info
109: where rule_type = 'LOCAL_LOOKUP'
110: and legislation_code = p_legislation_code
111: and field_name = p_lookup_code
112: and validation_type = p_lookup_type;