APPS.BEN_DT_TRGR_HANDLE dependencies on PER_PERSON_TYPE_USAGES_F

Line 651: from per_person_type_usages_f

647: ,null
648: ,PERSON_TYPE_ID
649: ,EFFECTIVE_START_DATE
650: ,EFFECTIVE_END_DATE
651: from per_person_type_usages_f
652: where rowid = p_rowid;
653: --
654: l_old_rec ben_ptu_ler.g_ptu_ler_rec;
655: l_new_rec ben_ptu_ler.g_ptu_ler_rec;

Line 742: from per_person_type_usages_f ptu,

738: l_ptu_system_person_type per_person_types.system_person_type%type;
739: --
740: cursor c1_revterm_ptu is
741: select ptu.person_id, ppt.system_person_type
742: from per_person_type_usages_f ptu,
743: per_person_types ppt
744: where ptu.person_id in (select pcr.contact_person_id
745: from per_contact_relationships pcr
746: where pcr.person_id = p_person_id