APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on FND_LOOKUP_VALUES

Line 536: FROM fnd_lookup_values

532: IS
533:
534: CURSOR c_blk_name IS
535: SELECT meaning
536: FROM fnd_lookup_values
537: WHERE lookup_code = p_code
538: AND view_application_id = 8405
539: AND enabled_flag='Y'
540: AND language = USERENV('LANG')

Line 591: FROM fnd_lookup_values

587: IS
588:
589: CURSOR c_blk_name IS
590: SELECT SUBSTR(meaning,5,2)
591: FROM fnd_lookup_values
592: WHERE lookup_type = 'PQP_US_COUNTRY_TRANSLATE'
593: AND view_application_id = 3
594: AND lookup_code=p_code
595: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE-1) AND NVL(end_date_active, SYSDATE + 1);

Line 690: FROM fnd_lookup_values lv

686: ) RETURN VARCHAR2 IS
687:
688: CURSOR c_visa_type IS
689: SELECT lv.lookup_code
690: FROM fnd_lookup_values lv
691: WHERE lv.lookup_type = 'SV_MAP_HR_VISA_TYPES'
692: AND lv.meaning = p_visa_meaning
693: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE-1) AND NVL(end_date_active, SYSDATE + 1);
694:

Line 744: FROM fnd_lookup_values

740: IS
741:
742: CURSOR c_name_suffix IS
743: SELECT tag
744: FROM fnd_lookup_values
745: WHERE lookup_code = p_code
746: AND view_application_id = 8405
747: AND enabled_flag = 'Y'
748: AND language = USERENV('LANG')

Line 895: FROM fnd_lookup_values

891: IS
892:
893: CURSOR c_name IS
894: SELECT tag
895: FROM fnd_lookup_values
896: WHERE lookup_code = p_code
897: AND view_application_id = 8405
898: AND enabled_flag = 'Y'
899: AND language = USERENV('LANG')