APPS.IGF_SE_GEN_001 dependencies on HZ_PERSON_PROFILES

Line 325: FROM HZ_PERSON_PROFILES

321: ORDER BY a.visa_expiry_date DESC;
322:
323: CURSOR c_stat (cv_person_id hz_parties.party_id%TYPE ) IS
324: SELECT NVL(marital_status,'NA') marital_status
325: FROM HZ_PERSON_PROFILES
326: WHERE party_id = cv_person_id
327: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE);
328:
329: CURSOR c_accept_amnt(