DBA Data[Home] [Help]

APPS.HR_LOOKUPS_UTIL_PKG dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 17: data that is created in PAY_LEGISLATIVE_FIELD_INFO

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:

Line 64: from pay_legislative_field_info

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;

Line 108: from pay_legislative_field_info

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;