APPS.IGS_AD_IMP_007 dependencies on IGS_PE_PERSON_BASE_V

Line 206: FROM IGS_PE_PERSON_BASE_V

202: ) AS
203:
204: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
205: SELECT Birth_date
206: FROM IGS_PE_PERSON_BASE_V
207: WHERE person_id= p_person_id;
208:
209:
210: l_var VARCHAR2(1);

Line 705: FROM igs_pe_person_base_v

701: || (reverse chronological order - newest change first)
702: */
703: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
704: SELECT birth_date
705: FROM igs_pe_person_base_v
706: WHERE person_id = p_person_id;
707:
708: l_birth_date igs_ad_interface.birth_dt%TYPE;
709: l_rec VARCHAR2(1);

Line 1444: FROM igs_pe_person_base_v

1440: PROCEDURE Validate_health_Ins(hlth_ins_rec IN HLTH_INS%ROWTYPE, l_check OUT NOCOPY VARCHAR2) AS
1441:
1442: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
1443: SELECT birth_date
1444: FROM igs_pe_person_base_v
1445: WHERE person_id= p_person_id;
1446:
1447: l_var VARCHAR2(1);
1448: l_birth_dt IGS_AD_INTERFACE.BIRTH_DT%TYPE;

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

2663: SELECT territory_short_name
2664: FROM fnd_territories_vl
2665: WHERE territory_code = cp_territory_code;
2666:
2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2668: SELECT birth_date FROM
2669: igs_pe_person_base_v WHERE
2670: person_id = cp_person_id;
2671:

Line 2669: igs_pe_person_base_v WHERE

2665: WHERE territory_code = cp_territory_code;
2666:
2667: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2668: SELECT birth_date FROM
2669: igs_pe_person_base_v WHERE
2670: person_id = cp_person_id;
2671:
2672: CURSOR date_overlap(PCZ_REC c_pcz%ROWTYPE) IS
2673: SELECT count(1) FROM HZ_CITIZENSHIP

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

2919: WHERE party_id = pcz_rec.person_id
2920: AND country_code =pcz_rec.country_code
2921: AND date_recognized = pcz_rec.date_recognized;
2922:
2923: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2924: SELECT birth_date
2925: FROM igs_pe_person_base_v
2926: WHERE person_id = pcz_rec.person_id;
2927:

Line 2925: FROM igs_pe_person_base_v

2921: AND date_recognized = pcz_rec.date_recognized;
2922:
2923: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2924: SELECT birth_date
2925: FROM igs_pe_person_base_v
2926: WHERE person_id = pcz_rec.person_id;
2927:
2928: CURSOR date_overlap(PCZ_REC c_pcz%ROWTYPE) IS
2929: SELECT COUNT(1)