APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERSON_TYPE_USAGES_F

Line 3110: FROM per_person_types typ, per_person_type_usages_f ptu

3106: CURSOR c_get_type (
3107: p_person_id NUMBER
3108: ) IS
3109: SELECT typ.system_person_type
3110: FROM per_person_types typ, per_person_type_usages_f ptu
3111: WHERE typ.person_type_id = ptu.person_type_id
3112: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3113: AND ptu.person_id = p_person_id;
3114: BEGIN