APPS.PER_FR_BIAF_REPORT dependencies on PER_PERSON_TYPES

Line 450: -- per_person_types_v pt,

446: ) IS
447: SELECT COUNT(asg.assignment_id)
448: FROM per_all_assignments_f asg,
449: per_assignment_status_types ast,
450: -- per_person_types_v pt,
451: per_all_people_f peo
452: WHERE asg.establishment_id=p_est_id
453: AND asg.person_id = peo.person_id
454: AND (ast.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN')) -- AND p_include_suspended = 'Y')

Line 459: per_person_types pt

455: AND asg.assignment_status_type_id = ast.assignment_status_type_id
456: AND asg.primary_flag = 'Y'
457: and exists ( select null
458: from per_person_type_usages_f pf,
459: per_person_types pt
460: where pf.person_id=peo.person_id
461: and pf.person_type_id = pt.person_type_id
462: --and pt.language=userenv('lang')
463: and 'Y' = pefrusdt.get_table_value(peo.business_group_id

Line 485: -- per_person_types_v pt2,

481: AND (LEAST(asg.effective_end_date,peo.effective_end_date) > p_effective_date
482: OR EXISTS (SELECT null
483: FROM per_all_assignments_f asg2,
484: per_assignment_status_types ast2,
485: -- per_person_types_v pt2,
486: per_all_people_f peo2
487: WHERE asg2.establishment_id =p_est_id
488: AND asg2.person_id = peo.person_id
489: AND asg2.person_id = peo2.person_id

Line 494: from per_person_type_usages_f pf2, per_person_types pt2

490: AND (ast2.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN') AND p_include_suspended = 'Y')
491: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id
492: AND asg2.primary_flag = 'Y'
493: and exists ( select null
494: from per_person_type_usages_f pf2, per_person_types pt2
495: where pf2.person_id=peo2.person_id
496: and pf2.person_type_id = pt2.person_type_id
497: and 'Y' = pefrusdt.get_table_value(peo2.business_group_id
498: ,'FR_USER_PERSON_TYPE'