APPS.IGS_AD_IMP_011 dependencies on IGS_PE_PERSON_BASE_V

Line 129: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

125: FUNCTION validate_record ( acadhonor_rec hnr_cur%ROWTYPE) RETURN VARCHAR2
126: AS
127: l_return_val VARCHAR2(1) := 'Y';
128: l_var VARCHAR2(1);
129: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
130: SELECT birth_date birth_dt
131: FROM igs_pe_person_base_v
132: WHERE person_id = cp_person_id;
133: birth_dt_rec birth_dt_cur%ROWTYPE;

Line 131: FROM igs_pe_person_base_v

127: l_return_val VARCHAR2(1) := 'Y';
128: l_var VARCHAR2(1);
129: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
130: SELECT birth_date birth_dt
131: FROM igs_pe_person_base_v
132: WHERE person_id = cp_person_id;
133: birth_dt_rec birth_dt_cur%ROWTYPE;
134: l_bdate DATE;
135: BEGIN

Line 633: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

629: p_error_code OUT NOCOPY VARCHAR2,
630: p_mode VARCHAR2)
631: AS
632:
633: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
634: SELECT birth_date birth_dt
635: FROM igs_pe_person_base_v
636: WHERE person_id = cp_person_id;
637:

Line 635: FROM igs_pe_person_base_v

631: AS
632:
633: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
634: SELECT birth_date birth_dt
635: FROM igs_pe_person_base_v
636: WHERE person_id = cp_person_id;
637:
638: CURSOR load_cal_cur (cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
639: IS

Line 1312: CURSOR validate_interviewer_cur(cp_interviewer_id igs_pe_person_base_v.person_id%TYPE) IS

1308: FROM igs_ad_disbl_type
1309: WHERE disability_type = cp_disability_type AND
1310: closed_ind = cp_closed_ind;
1311:
1312: CURSOR validate_interviewer_cur(cp_interviewer_id igs_pe_person_base_v.person_id%TYPE) IS
1313: SELECT birth_date
1314: FROM igs_pe_person_base_v
1315: WHERE person_id = cp_interviewer_id;
1316:

Line 1314: FROM igs_pe_person_base_v

1310: closed_ind = cp_closed_ind;
1311:
1312: CURSOR validate_interviewer_cur(cp_interviewer_id igs_pe_person_base_v.person_id%TYPE) IS
1313: SELECT birth_date
1314: FROM igs_pe_person_base_v
1315: WHERE person_id = cp_interviewer_id;
1316:
1317: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
1318: SELECT birth_date

Line 1319: FROM igs_pe_person_base_v

1315: WHERE person_id = cp_interviewer_id;
1316:
1317: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
1318: SELECT birth_date
1319: FROM igs_pe_person_base_v
1320: WHERE person_id= p_person_id;
1321:
1322: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
1323: l_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE;

Line 1494: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1490: || kumma 21-OCT-2002 Added validations for start date and end date
1491: || (reverse chronological order - newest change first)
1492: */
1493:
1494: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1495: SELECT birth_date
1496: FROM igs_pe_person_base_v
1497: WHERE person_id= cp_person_id;
1498:

Line 1496: FROM igs_pe_person_base_v

1492: */
1493:
1494: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1495: SELECT birth_date
1496: FROM igs_pe_person_base_v
1497: WHERE person_id= cp_person_id;
1498:
1499: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
1500: BEGIN

Line 1594: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1590: || Change History :
1591: || Who When What
1592: || (reverse chronological order - newest change first)
1593: */
1594: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1595: SELECT birth_date
1596: FROM igs_pe_person_base_v
1597: WHERE person_id= cp_person_id;
1598:

Line 1596: FROM igs_pe_person_base_v

1592: || (reverse chronological order - newest change first)
1593: */
1594: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1595: SELECT birth_date
1596: FROM igs_pe_person_base_v
1597: WHERE person_id= cp_person_id;
1598:
1599: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
1600: BEGIN