DBA Data[Home] [Help]

APPS.PER_FR_BIAF_REPORT dependencies on PER_PERSON_TYPE_USAGES_F

Line 458: from per_person_type_usages_f pf,

454: AND (ast.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN')) -- AND p_include_suspended = 'Y')
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')

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'