APPS.PAY_US_1099R_UDFS dependencies on HR_LOOKUPS

Line 324: SELECT 'Y' into l_flag from hr_lookups

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

Line 343: SELECT MEANING into l_code from hr_lookups

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