eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_FR_BIAF_REPORT dependencies on PEFRUSDT

Line 463: and 'Y' = pefrusdt.get_table_value(peo.business_group_id

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
464: ,'FR_USER_PERSON_TYPE'
465: ,p_udt_column
466: ,pt.user_person_type
467: ,p_effective_date)

Line 471: AND 'Y' = pefrusdt.get_table_value(peo.business_group_id

467: ,p_effective_date)
468: and p_effective_date between pf.effective_start_date and pf.effective_end_date
469: )
470: /*AND peo.person_type_id = pt.person_type_id
471: AND 'Y' = pefrusdt.get_table_value(peo.business_group_id
472: ,'FR_USER_PERSON_TYPE'
473: ,p_udt_column
474: ,pt.user_person_type
475: ,p_effective_date)*/

Line 497: and 'Y' = pefrusdt.get_table_value(peo2.business_group_id

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'
499: ,p_udt_column
500: ,pt2.user_person_type
501: ,p_effective_date)

Line 504: AND 'Y' = pefrusdt.get_table_value(peo2.business_group_id

500: ,pt2.user_person_type
501: ,p_effective_date)
502: )
503: /*AND peo2.person_type_id = pt2.person_type_id
504: AND 'Y' = pefrusdt.get_table_value(peo2.business_group_id
505: ,'FR_USER_PERSON_TYPE'
506: ,p_udt_column
507: ,pt2.user_person_type
508: ,p_effective_date)