322: sraj 2000/05/05 the table structure has been changed
323: sjalasut June 7, 2002 bug 2381248
324: (reverse chronological order - newest change first)
325: ***************************************************************/
326: CURSOR c_get_birth_date is SELECT date_of_birth FROM HZ_PERSON_PROFILES WHERE PARTY_ID = x_person_id
327: AND EFFECTIVE_END_DATE IS NULL;
328: l_birth_date HZ_PERSON_PROFILES.date_of_birth%TYPE;
329:
330: BEGIN
324: (reverse chronological order - newest change first)
325: ***************************************************************/
326: CURSOR c_get_birth_date is SELECT date_of_birth FROM HZ_PERSON_PROFILES WHERE PARTY_ID = x_person_id
327: AND EFFECTIVE_END_DATE IS NULL;
328: l_birth_date HZ_PERSON_PROFILES.date_of_birth%TYPE;
329:
330: BEGIN
331:
332: Set_Column_Values (