APPS.IGR_I_APPL_PKG dependencies on IGS_PE_PERSON_BASE_V

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

134: p_inserting IN BOOLEAN DEFAULT FALSE,
135: p_updating IN BOOLEAN DEFAULT FALSE,
136: p_deleting IN BOOLEAN DEFAULT FALSE
137: ) as
138: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
139: SELECT birth_date
140: FROM igs_pe_person_base_v
141: WHERE person_id =p_person_id ;
142:

Line 140: FROM igs_pe_person_base_v

136: p_deleting IN BOOLEAN DEFAULT FALSE
137: ) as
138: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
139: SELECT birth_date
140: FROM igs_pe_person_base_v
141: WHERE person_id =p_person_id ;
142:
143: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
144: SELECT deceased_ind

Line 149: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

145: FROM igs_pe_hz_parties
146: WHERE party_id = cp_party_id;
147: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
148: v_message_name varchar2(30);
149: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
150:
151: BEGIN
152: -- Fetch the Deceased Indicator
153: IF p_inserting OR p_updating THEN