APPS.IGS_CO_GEN_003 dependencies on IGS_PE_EIT

Line 355: FROM igs_pe_eit peit,

351: --Cursor to get the Student Citizenship Status.
352: --
353: CURSOR cur_citizenship IS
354: SELECT peit.pei_information1 restatus_code, pecc.meaning restatus_desc
355: FROM igs_pe_eit peit,
356: igs_lookups_view pecc
357: WHERE peit.pei_information1 = pecc.lookup_code
358: AND peit.person_id = p_person_id
359: AND peit.start_date <= SYSDATE

Line 364: l_restatus_code igs_pe_eit.pei_information1%TYPE;

360: AND NVL(peit.end_date,SYSDATE) >= SYSDATE
361: AND pecc.lookup_type='PE_CITI_STATUS'
362: AND ENABLED_FLAG = 'Y';
363:
364: l_restatus_code igs_pe_eit.pei_information1%TYPE;
365: l_restatus_desc igs_lookups_view.meaning%TYPE;
366:
367: BEGIN
368: