APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_PERSON_ID_TYP

Line 1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS

1858: AND person_id_type = cp_pers_id_type
1859: ORDER BY START_DT DESC;
1860: cur_alt_pers_dtls_rec cur_alt_pers_dtls%ROWTYPE;
1861:
1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
1863: SELECT 'X'
1864: FROM IGS_PE_PERSON_ID_TYP
1865: WHERE person_id_type = cp_person_id_type
1866: AND unique_ind = 'Y'

Line 1864: FROM IGS_PE_PERSON_ID_TYP

1860: cur_alt_pers_dtls_rec cur_alt_pers_dtls%ROWTYPE;
1861:
1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
1863: SELECT 'X'
1864: FROM IGS_PE_PERSON_ID_TYP
1865: WHERE person_id_type = cp_person_id_type
1866: AND unique_ind = 'Y'
1867: AND closed_ind = 'N';
1868: