APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_ALT_PERS_ID

Line 4213: FROM IGS_PE_ALT_PERS_ID

4209: AS
4210: CURSOR chk_any_ucas_active_id(cp_person_id NUMBER,cp_api_type VARCHAR2)
4211: IS
4212: SELECT api_person_id
4213: FROM IGS_PE_ALT_PERS_ID
4214: WHERE pe_person_id = cp_person_id
4215: AND person_id_type = cp_api_type
4216: AND SYSDATE BETWEEN TRUNC(START_DT) AND NVL(END_DT,SYSDATE);
4217:

Line 4218: l_ucas_id igs_pe_alt_pers_id.api_person_id%TYPE ;

4214: WHERE pe_person_id = cp_person_id
4215: AND person_id_type = cp_api_type
4216: AND SYSDATE BETWEEN TRUNC(START_DT) AND NVL(END_DT,SYSDATE);
4217:
4218: l_ucas_id igs_pe_alt_pers_id.api_person_id%TYPE ;
4219: l_api_id igs_pe_alt_pers_id.api_person_id%TYPE;
4220: l_start_dt DATE;
4221: l_end_dt DATE;
4222:

Line 4219: l_api_id igs_pe_alt_pers_id.api_person_id%TYPE;

4215: AND person_id_type = cp_api_type
4216: AND SYSDATE BETWEEN TRUNC(START_DT) AND NVL(END_DT,SYSDATE);
4217:
4218: l_ucas_id igs_pe_alt_pers_id.api_person_id%TYPE ;
4219: l_api_id igs_pe_alt_pers_id.api_person_id%TYPE;
4220: l_start_dt DATE;
4221: l_end_dt DATE;
4222:
4223: BEGIN