APPS.IGS_PE_VAL_PIGM dependencies on IGS_PE_PERSON_ID_TYP

Line 141: FROM IGS_PE_ALT_PERS_ID pa,IGS_PE_PERSON_ID_TYP pt

137: ----------------------------------------------------------------------------------------------
138:
139: CURSOR cur_pers_obsolete IS
140: SELECT 'X'
141: FROM IGS_PE_ALT_PERS_ID pa,IGS_PE_PERSON_ID_TYP pt
142: WHERE pa.PE_PERSON_ID=p_person_id
143: AND pa.person_id_type=pt.person_id_type
144: AND pt.s_person_id_type='MERGE-INTO';
145: l_cur_pers_obsolete VARCHAR2(1);