DBA Data[Home] [Help]

APPS.BEN_IREC_BACK_OUT_CONC dependencies on PER_PERSON_TYPES

Line 519: per_person_types ppt, per_all_assignments_f apl_ass

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
523: and apl_ass.business_group_id = p_business_group_id