593: WHERE association_code = p_assoc
594: AND map1 = p_map1;
595:
596: -- TITLE validation
597: CURSOR cur_chk_adjunct (p_adjunct fnd_lookup_values.lookup_code%TYPE) IS
598: SELECT lookup_code
599: FROM fnd_lookup_values
600: WHERE lookup_Type = 'CONTACT_TITLE'
601: AND lookup_code = p_adjunct
595:
596: -- TITLE validation
597: CURSOR cur_chk_adjunct (p_adjunct fnd_lookup_values.lookup_code%TYPE) IS
598: SELECT lookup_code
599: FROM fnd_lookup_values
600: WHERE lookup_Type = 'CONTACT_TITLE'
601: AND lookup_code = p_adjunct
602: AND enabled_flag = 'Y'
603: AND LANGUAGE = USERENV('LANG') AND view_application_id = 222 AND security_group_id(+) = 0;