APPS.IGS_AD_IMP_008 dependencies on IGS_PE_PERSON_BASE_V

Line 1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1047: SELECT territory_short_name
1048: FROM fnd_territories_vl
1049: WHERE territory_code = p_territory_code;
1050:
1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1052: SELECT birth_date
1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:

Line 1053: FROM igs_pe_person_base_v

1049: WHERE territory_code = p_territory_code;
1050:
1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1052: SELECT birth_date
1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:
1056: l_Status igs_ad_relations_int.status%TYPE;
1057: l_Error_Code igs_ad_relations_int.error_code%TYPE;

Line 2455: FROM igs_pe_person_base_v

2451:
2452: CURSOR birth_date_cur(cp_person_id hz_parties.party_id%TYPE)
2453: IS
2454: SELECT birth_date
2455: FROM igs_pe_person_base_v
2456: WHERE person_id = cp_person_id;
2457:
2458:
2459: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

3370: WHERE party_type = 'ORGANIZATION' AND
3371: party_number = cp_employer_party_number AND
3372: status <> 'M';
3373:
3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3375: SELECT birth_date
3376: FROM igs_pe_person_base_v
3377: WHERE person_id = cp_person_id;
3378:

Line 3376: FROM igs_pe_person_base_v

3372: status <> 'M';
3373:
3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3375: SELECT birth_date
3376: FROM igs_pe_person_base_v
3377: WHERE person_id = cp_person_id;
3378:
3379: lv_var VARCHAR2(1);
3380: l_count NUMBER(3);

Line 4028: FROM IGS_PE_PERSON_BASE_V WHERE PERSON_ID =p_person_id;

4024: IF p_per_stat.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
4025: DECLARE
4026: CURSOR c_mar_eff_dt(p_person_id igs_pe_person.person_id%TYPE) IS
4027: SELECT BIRTH_DATE
4028: FROM IGS_PE_PERSON_BASE_V WHERE PERSON_ID =p_person_id;
4029:
4030: BEGIN
4031: OPEN c_mar_eff_dt(p_per_stat.pid);
4032: FETCH c_mar_eff_dt INTO l_birth_date;

Line 5283: FROM igs_pe_person_base_v

5279:
5280: -- Validate date of birth
5281: CURSOR birth_date_cur(cp_person_id NUMBER) IS
5282: SELECT birth_date
5283: FROM igs_pe_person_base_v
5284: WHERE person_id = cp_person_id;
5285:
5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
5287: l_error VARCHAR2(30);

Line 5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

5282: SELECT birth_date
5283: FROM igs_pe_person_base_v
5284: WHERE person_id = cp_person_id;
5285:
5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
5287: l_error VARCHAR2(30);
5288: BEGIN
5289: -- Call Log header
5290: