APPS.IGS_AD_EXTRACURR_ACT_PKG dependencies on HZ_PERSON_PROFILES

Line 37: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES

33: l_hz_extracurr_act_id NUMBER;
34:
35: tmp_var1 VARCHAR2(2000);
36: tmp_var VARCHAR2(2000);
37: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
38: WHERE party_id = x_person_id AND effective_end_Date is null;
39: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
40:
41:

Line 39: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

35: tmp_var1 VARCHAR2(2000);
36: tmp_var VARCHAR2(2000);
37: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
38: WHERE party_id = x_person_id AND effective_end_Date is null;
39: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
40:
41:
42: BEGIN
43:

Line 228: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES

224: PERSON_INTEREST_ID = x_person_interest_id;
225: tmp_var1 VARCHAR2(2000);
226: tmp_var VARCHAR2(2000);
227:
228: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
229: WHERE party_id = x_person_id AND effective_end_Date is null;
230: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
231:
232:

Line 230: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

226: tmp_var VARCHAR2(2000);
227:
228: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
229: WHERE party_id = x_person_id AND effective_end_Date is null;
230: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
231:
232:
233: BEGIN
234: