APPS.BEN_CONC_REPORTS dependencies on PER_PERSON_TYPE_USAGES

Line 949: from per_person_type_usages ptu

945: and paf2.assignment_type='E')) ))
946: /* person exists with specified person type */
947: and (g_parm.person_type_id is null
948: or exists (select null
949: from per_person_type_usages ptu
950: where ptu.person_id = pen.person_id
951: and ptu.person_type_id = g_parm.person_type_id))
952: /* person exists with specified assignment type */
953: and (g_parm.assgn_type is null

Line 1127: from per_person_type_usages ptu

1123: and per.effective_end_date ))
1124: /* person exists with specified person type */
1125: and (g_parm.person_type_id is null
1126: or exists (select null
1127: from per_person_type_usages ptu
1128: where ptu.person_id = pil.person_id
1129: and ptu.person_type_id = g_parm.person_type_id))
1130: /* person exists with specified assignment type */
1131: and (g_parm.assgn_type is null