APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERSON_TYPE_USAGES_F

Line 3128: FROM per_person_types typ, per_person_type_usages_f ptu

3124: CURSOR c_get_type (
3125: p_person_id NUMBER
3126: ) IS
3127: SELECT typ.system_person_type
3128: FROM per_person_types typ, per_person_type_usages_f ptu
3129: WHERE typ.person_type_id = ptu.person_type_id
3130: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3131: AND ptu.person_id = p_person_id;
3132: BEGIN