APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 261: FROM igs_pe_person_id_typ

257: l_app VARCHAR2(50);
258:
259: CURSOR pref_id_cur IS
260: SELECT person_id_type, description, format_mask
261: FROM igs_pe_person_id_typ
262: WHERE preferred_ind ='Y';
263:
264: pref_id_rec pref_id_cur%ROWTYPE;
265:

Line 1794: FROM igs_pe_person_id_typ

1790: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
1791:
1792: CURSOR c_alt_id_desc(cp_alt_id_type in VARCHAR) IS
1793: SELECT description
1794: FROM igs_pe_person_id_typ
1795: WHERE person_id_type= cp_alt_id_type;
1796:
1797: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1798:

Line 1797: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;

1793: SELECT description
1794: FROM igs_pe_person_id_typ
1795: WHERE person_id_type= cp_alt_id_type;
1796:
1797: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1798:
1799: BEGIN
1800:
1801: -- Initialize message list if p_init_msg_list is set to TRUE.