DBA Data[Home] [Help]

APPS.PER_RO_NI_VALIDATION dependencies on HR_LOOKUPS

Line 97: select LOOKUP_CODE from hr_lookups where LOOKUP_TYPE = 'RO_PER_COUNTIES' and MEANING = county_name;

93: l_date number;
94: l_county number;
95:
96: cursor c_county_code(county_name in varchar2) is
97: select LOOKUP_CODE from hr_lookups where LOOKUP_TYPE = 'RO_PER_COUNTIES' and MEANING = county_name;
98:
99: begin
100: --hr_utility.trace_on(null,'Test');
101: hr_utility.set_location('NI_VALIDATION :: ',200);