APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on FND_LOOKUP_VALUES

Line 531: FROM fnd_lookup_values

527: IS
528:
529: CURSOR c_blk_name IS
530: SELECT meaning
531: FROM fnd_lookup_values
532: WHERE lookup_code = p_code
533: AND view_application_id = 8405
534: AND enabled_flag='Y'
535: AND language = USERENV('LANG')

Line 586: FROM fnd_lookup_values

582: IS
583:
584: CURSOR c_blk_name IS
585: SELECT SUBSTR(meaning,5,2)
586: FROM fnd_lookup_values
587: WHERE lookup_type = 'PQP_US_COUNTRY_TRANSLATE'
588: AND view_application_id = 3
589: AND lookup_code=p_code
590: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE-1) AND NVL(end_date_active, SYSDATE + 1);

Line 646: FROM fnd_lookup_values lv

642: ) RETURN VARCHAR2 IS
643:
644: CURSOR c_visa_type IS
645: SELECT lv.lookup_code
646: FROM fnd_lookup_values lv
647: WHERE lv.lookup_type = 'SV_MAP_HR_VISA_TYPES'
648: AND lv.meaning = p_visa_meaning
649: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE-1) AND NVL(end_date_active, SYSDATE + 1);
650:

Line 700: FROM fnd_lookup_values

696: IS
697:
698: CURSOR c_name_suffix IS
699: SELECT tag
700: FROM fnd_lookup_values
701: WHERE lookup_code = p_code
702: AND view_application_id = 8405
703: AND enabled_flag = 'Y'
704: AND language = USERENV('LANG')

Line 851: FROM fnd_lookup_values

847: IS
848:
849: CURSOR c_name IS
850: SELECT tag
851: FROM fnd_lookup_values
852: WHERE lookup_code = p_code
853: AND view_application_id = 8405
854: AND enabled_flag = 'Y'
855: AND language = USERENV('LANG')