APPS.IGS_PE_PERSON_ADDR_PKG dependencies on HZ_PERSON_PROFILES

Line 52: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES

48: p_party_site_rec_insert HZ_PARTY_SITE_V2PUB.party_site_rec_type;
49: l_addr_val_status VARCHAR2(30);
50: l_addr_warn_msg VARCHAR2(2000);
51:
52: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES
53: WHERE party_id = p_party_id AND effective_end_Date IS NULL;
54: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
55:
56: CURSOR c_party_site_number IS

Line 54: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

50: l_addr_warn_msg VARCHAR2(2000);
51:
52: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES
53: WHERE party_id = p_party_id AND effective_end_Date IS NULL;
54: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
55:
56: CURSOR c_party_site_number IS
57: SELECT hz_party_site_number_s.NEXTVAL
58: FROM dual;

Line 247: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES

243: l_start_dt DATE;
244: l_addr_val_status VARCHAR2(30);
245: l_addr_warn_msg VARCHAR2(2000);
246:
247: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES
248: WHERE party_id = p_party_id AND effective_end_Date IS NULL;
249: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
250:
251:

Line 249: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

245: l_addr_warn_msg VARCHAR2(2000);
246:
247: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES
248: WHERE party_id = p_party_id AND effective_end_Date IS NULL;
249: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
250:
251:
252: CURSOR get_rowid(p_party_site_id NUMBER) IS
253: SELECT ROWID,start_date