APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON_BASE_V

Line 680: FROM IGS_PE_PERSON_BASE_V WHERE

676: IF stat_rec.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
677: DECLARE
678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS
679: SELECT BIRTH_DATE
680: FROM IGS_PE_PERSON_BASE_V WHERE
681: PERSON_ID =cp_person_id;
682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
683: BEGIN
684: IF l_birth_date IS NOT NULL THEN

Line 682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

678: CURSOR c_mar_eff_dt(cp_person_id igs_pe_person.person_id%TYPE) IS
679: SELECT BIRTH_DATE
680: FROM IGS_PE_PERSON_BASE_V WHERE
681: PERSON_ID =cp_person_id;
682: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
683: BEGIN
684: IF l_birth_date IS NOT NULL THEN
685: OPEN c_mar_eff_dt(p_person_id);
686: FETCH c_mar_eff_dt INTO l_birth_date;

Line 3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,

3569: END prc_pe_dtls;
3570:
3571:
3572: PROCEDURE validate_address (p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,
3574: p_status OUT NOCOPY VARCHAR2,
3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

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

3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,
3574: p_status OUT NOCOPY VARCHAR2,
3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3578: SELECT birth_date
3579: FROM igs_pe_person_base_v
3580: WHERE person_id = cp_person_id;
3581:

Line 3579: FROM igs_pe_person_base_v

3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576:
3577: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3578: SELECT birth_date
3579: FROM igs_pe_person_base_v
3580: WHERE person_id = cp_person_id;
3581:
3582: CURSOR terr_name_cur(cp_territory_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE) IS
3583: SELECT territory_short_name

Line 3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

3583: SELECT territory_short_name
3584: FROM FND_TERRITORIES_VL
3585: WHERE territory_code = UPPER(cp_territory_code);
3586:
3587: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
3588: l_territory_short_name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
3589: BEGIN
3590:
3591: