APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on FND_LOOKUP_VALUES

Line 2621: FROM fnd_lookup_values

2617:
2618: --To get the Email format to populate into igs_ad_contacts_int_all table.
2619: CURSOR cur_email_format IS
2620: SELECT lookup_code
2621: FROM fnd_lookup_values
2622: WHERE lookup_type = 'EMAIL_FORMAT'
2623: AND enabled_flag ='Y'
2624: AND NVL(START_DATE_ACTIVE,SYSDATE) <=SYSDATE
2625: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

Line 2628: l_email_format FND_LOOKUP_VALUES.lookup_code%TYPE;

2624: AND NVL(START_DATE_ACTIVE,SYSDATE) <=SYSDATE
2625: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
2626: AND LANGUAGE = USERENV('LANG') AND view_application_id = 222 AND security_group_id(+) = 0;
2627:
2628: l_email_format FND_LOOKUP_VALUES.lookup_code%TYPE;
2629:
2630: BEGIN
2631:
2632: -- Populate the Admission Contacts Interface Table for Primary Phone Number