APPS.BEN_IREC_BACK_OUT_CONC dependencies on PER_PERSON_TYPE_USAGES_F

Line 518: and exists ( select null from per_person_type_usages_f ptu,

514: and pil.person_id = p_person_id
515: and pil.assignment_id = p_assignment_id
516: and ler.typ_cd ='IREC'
517: )
518: and exists ( select null from per_person_type_usages_f ptu,
519: per_person_types ppt, per_all_assignments_f apl_ass
520: where ppt.person_type_id = ptu.person_type_id
521: and ppt.system_person_type in( 'APL', 'APL_EX_APL','EMP_APL', 'EX_EMP_APL')
522: and ppt.business_group_id = ppf.business_group_id