APPS.HRI_OPL_PERSON_TYPE_CTGRY dependencies on PER_PERSON_TYPES

Line 345: FROM per_person_types ppt

341: DELETE FROM hri_cs_prsntyp_ct dim
342: WHERE dim.prsntyp_sk_pk <> -1
343: AND dim.person_type_id NOT IN
344: (SELECT ppt.person_type_id
345: FROM per_person_types ppt
346: WHERE ppt.system_person_type IN ('EMP','CWK'));
347:
348: -- Delete any obsolete employment categories
349: DELETE FROM hri_cs_prsntyp_ct dim