1731: l_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE;
1732:
1733: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
1734: SELECT Birth_date
1735: FROM IGS_PE_PERSON_BASE_V
1736: WHERE person_id= p_person_id;
1737:
1738: BEGIN
1739:
2264: l_birth_dt IGS_AD_INTERFACE.BIRTH_DT%TYPE;
2265:
2266: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
2267: SELECT Birth_date
2268: FROM IGS_PE_PERSON_BASE_V
2269: WHERE person_id= p_person_id;
2270: BEGIN
2271:
2272: -- ATHLETIC_PRG_CD