APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_ALT_PERS_ID

Line 3472: FROM igs_pe_alt_pers_id api

3468: l_altid VARCHAR2(1000);
3469:
3470: CURSOR c_altpid(cp_pe_person_id number) is
3471: SELECT api_person_id, person_id_type
3472: FROM igs_pe_alt_pers_id api
3473: WHERE api.pe_person_id = cp_pe_person_id
3474: AND Sysdate between api.start_dt and nvl(api.end_dt, sysdate);
3475:
3476: BEGIN

Line 3630: FROM IGS_PE_ALT_PERS_ID

3626:
3627: -- Identification- ALT_ID
3628: CURSOR c_altId(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS
3629: SELECT 'x'
3630: FROM IGS_PE_ALT_PERS_ID
3631: WHERE PE_PERSON_ID = cp_person_id
3632: AND PERSON_ID_TYPE IN
3633: (SELECT SS_Lookup_code
3634: FROM igs_ad_ss_lookups