APPS.IGS_AD_PG_DATA_LOAD dependencies on IGS_PE_ALT_PERS_ID

Line 69: CURSOR c_api (cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,

65: v_last_char VARCHAR2(1);
66:
67: vtac_pg_filehandle UTL_FILE.FILE_TYPE;
68: vtac_filedir VARCHAR2(100);
69: CURSOR c_api (cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
70: cp_alt_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
71: SELECT pe_person_id
72: FROM IGS_PE_ALT_PERS_ID
73: WHERE api_person_id = cp_api_person_id

Line 70: cp_alt_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS

66:
67: vtac_pg_filehandle UTL_FILE.FILE_TYPE;
68: vtac_filedir VARCHAR2(100);
69: CURSOR c_api (cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
70: cp_alt_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
71: SELECT pe_person_id
72: FROM IGS_PE_ALT_PERS_ID
73: WHERE api_person_id = cp_api_person_id
74: AND person_id_type = cp_alt_person_id_type

Line 72: FROM IGS_PE_ALT_PERS_ID

68: vtac_filedir VARCHAR2(100);
69: CURSOR c_api (cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
70: cp_alt_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
71: SELECT pe_person_id
72: FROM IGS_PE_ALT_PERS_ID
73: WHERE api_person_id = cp_api_person_id
74: AND person_id_type = cp_alt_person_id_type
75: AND start_dt < SYSDATE
76: AND NVL(end_dt,SYSDATE) >= SYSDATE;