1849: WHO WHEN WHAT
1850:
1851: ***************************************************************** */
1852:
1853: CURSOR cur_alt_pers_dtls ( cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
1854: cp_pers_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1855: SELECT api_person_id, start_dt, end_dt
1856: FROM IGS_PE_ALT_PERS_ID
1857: WHERE pe_person_id = cp_person_id
1850:
1851: ***************************************************************** */
1852:
1853: CURSOR cur_alt_pers_dtls ( cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
1854: cp_pers_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1855: SELECT api_person_id, start_dt, end_dt
1856: FROM IGS_PE_ALT_PERS_ID
1857: WHERE pe_person_id = cp_person_id
1858: AND person_id_type = cp_pers_id_type
1852:
1853: CURSOR cur_alt_pers_dtls ( cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
1854: cp_pers_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1855: SELECT api_person_id, start_dt, end_dt
1856: FROM IGS_PE_ALT_PERS_ID
1857: WHERE pe_person_id = cp_person_id
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;
1865: WHERE person_id_type = cp_person_id_type
1866: AND unique_ind = 'Y'
1867: AND closed_ind = 'N';
1868:
1869: CURSOR cur_pers_id_exist ( cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
1870: cp_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1871: SELECT 'X'
1872: FROM IGS_PE_ALT_PERS_ID
1873: WHERE api_person_id = cp_api_person_id
1866: AND unique_ind = 'Y'
1867: AND closed_ind = 'N';
1868:
1869: CURSOR cur_pers_id_exist ( cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
1870: cp_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1871: SELECT 'X'
1872: FROM IGS_PE_ALT_PERS_ID
1873: WHERE api_person_id = cp_api_person_id
1874: AND person_id_type = cp_person_id_type;
1868:
1869: CURSOR cur_pers_id_exist ( cp_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE,
1870: cp_person_id_type IGS_PE_ALT_PERS_ID.person_id_type%TYPE) IS
1871: SELECT 'X'
1872: FROM IGS_PE_ALT_PERS_ID
1873: WHERE api_person_id = cp_api_person_id
1874: AND person_id_type = cp_person_id_type;
1875: l_dummy VARCHAR2(1);
1876: