APPS.IGS_AD_APPL_PERSTAT_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 80: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS

76: p_inserting IN BOOLEAN DEFAULT FALSE,
77: p_updating IN BOOLEAN DEFAULT FALSE,
78: p_deleting IN BOOLEAN DEFAULT FALSE
79: ) as
80: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
81: SELECT birth_date
82: FROM igs_pe_person_base_v
83: WHERE person_id =p_person_id ;
84:

Line 82: FROM igs_pe_person_base_v

78: p_deleting IN BOOLEAN DEFAULT FALSE
79: ) as
80: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
81: SELECT birth_date
82: FROM igs_pe_person_base_v
83: WHERE person_id =p_person_id ;
84:
85: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
86:

Line 85: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

81: SELECT birth_date
82: FROM igs_pe_person_base_v
83: WHERE person_id =p_person_id ;
84:
85: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
86:
87: BEGIN
88: OPEN c_birth_date(new_references.person_id);
89: FETCH c_birth_date INTO l_birth_date;