APPS.IGS_PS_WF_EVENT_PKG dependencies on PER_PEOPLE_F

Line 518: FROM per_person_type_usages_f usg,per_people_f peo,

514: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);
515:
516: CURSOR c_hr_person IS
517: SELECT peo.party_id
518: FROM per_person_type_usages_f usg,per_people_f peo,
519: igs_pe_per_type_map map
520: WHERE usg.person_id = peo.person_id AND
521: usg.person_type_id = map.per_person_type_id AND
522: SYSDATE BETWEEN usg.effective_start_date and usg.effective_end_date AND