APPS.IGS_EN_GEN_016 dependencies on IGS_PE_ALT_PERS_ID

Line 896: FROM igs_pe_alt_pers_id

892: --
893: -- cursor to fetch value for prefered person id type.
894: CURSOR cur_alt_pers_id(p_pers_id_type VARCHAR2,p_person_id NUMBER) IS
895: SELECT api_person_id
896: FROM igs_pe_alt_pers_id
897: WHERE person_id_type = p_pers_id_type AND
898: pe_person_id = p_person_id;
899:
900: --

Line 919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;

915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);
921: l_batch_desc_label VARCHAR2(200);
922: l_error_rec VARCHAR2(1):= 'N' ;
923: l_int_cnt NUMBER := 0;