APPS.IGS_CO_GEN_003 dependencies on IGS_LOOKUPS_VIEW

Line 356: igs_lookups_view pecc

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
360: AND NVL(peit.end_date,SYSDATE) >= SYSDATE

Line 365: l_restatus_desc igs_lookups_view.meaning%TYPE;

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:
369: -- Check if the required parameter values are passed as Null. If any of these are null then return NULL value