APPS.PAY_US_1099R_UDFS dependencies on HR_LOOKUPS

Line 320: SELECT 'Y' into l_flag from hr_lookups

316: -------------------------------------------------------------------------
317: FUNCTION combined_filer_1099R_state (p_state in VARCHAR2) RETURN VARCHAR2 IS
318: l_flag VARCHAR(2);
319: BEGIN
320: SELECT 'Y' into l_flag from hr_lookups
321: where lookup_type = '1099R_US_COMBINED_FILER_STATES'
322: and lookup_code = p_state;
323: return l_flag;
324:

Line 339: SELECT MEANING into l_code from hr_lookups

335: FUNCTION get_1099R_state_code (p_state in VARCHAR2) RETURN VARCHAR2 IS
336: l_code VARCHAR(80):=NULL;
337: --
338: BEGIN
339: SELECT MEANING into l_code from hr_lookups
340: where lookup_type = '1099R_US_COMBINED_FILER_STATES'
341: and lookup_code = p_state;
342: return l_code;
343: