APPS.IGS_AD_GEN_007 dependencies on IGS_PE_PERSON

Line 15: v_person_id IGS_PE_PERSON.person_id%TYPE;

11: -- This module attempts to find a person based on surname, birth date,
12: -- sex and first initial.
13: DECLARE
14: v_match BOOLEAN;
15: v_person_id IGS_PE_PERSON.person_id%TYPE;
16: v_dd_mm_yyyy NUMBER(8);
17: CURSOR c_person IS
18: SELECT person_id,
19: first_name given_names

Line 20: FROM igs_pe_person_base_v

16: v_dd_mm_yyyy NUMBER(8);
17: CURSOR c_person IS
18: SELECT person_id,
19: first_name given_names
20: FROM igs_pe_person_base_v
21: WHERE last_name = p_surname AND
22: birth_date = TO_DATE(p_birth_dt, 'DDMMYYYY') AND
23: gender = p_sex;
24: BEGIN

Line 165: v_person_id IGS_PE_PERSON.person_id%TYPE;

161: -- Return output parameters indicating whether or not data exists on person
162: -- detail
163: -- tables for the specified person ID.
164: DECLARE
165: v_person_id IGS_PE_PERSON.person_id%TYPE;
166:
167: CURSOR c_at IS
168: SELECT person_id
169: FROM igs_pe_athletic_dtl

Line 179: FROM IGS_PE_PERSON_ADDR pa,

175: WHERE pe_person_id = p_person_id ;
176:
177: CURSOR c_person IS
178: SELECT person_id
179: FROM IGS_PE_PERSON_ADDR pa,
180: IGS_CO_ADDR_TYPE adt
181: WHERE pa.person_id = p_person_id AND
182: adt.addr_type = pa.addr_type AND
183: pa.correspondence_ind = 'Y';

Line 217: FROM IGS_PE_PERSON_ALIAS

213: AND itax.person_id = coun.person_id;
214:
215: CURSOR c_pa IS
216: SELECT person_id
217: FROM IGS_PE_PERSON_ALIAS
218: WHERE person_id = p_person_id ;
219: CURSOR c_te IS
220: SELECT person_id
221: FROM IGS_AD_TER_EDU