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_BIL_SHD dependencies on HR_SUMMARY_RESTRICTION_USAGE

Line 550: hr_summary_restriction_usage ru,

546: p_bus_grp_id number) is
547: select rt.restriction_sql,
548: rt.title
549: from hr_summary_restriction_type rt,
550: hr_summary_restriction_usage ru,
551: hr_summary_valid_restriction vr
552: where vr.restriction_type_id = rt.restriction_type_id
553: and ru.valid_restriction_id = vr.valid_restriction_id
554: and ru.restriction_usage_id = p_ru_id

Line 756: hr_summary_restriction_usage rtu

752: cursor csr_get_datatype IS
753: select rt.data_type
754: from hr_summary_restriction_type rt,
755: hr_summary_valid_restriction vr,
756: hr_summary_restriction_usage rtu
757: where rt.restriction_type_id = vr.restriction_type_id
758: and rt.business_group_id = vr.business_group_id
759: and vr.valid_restriction_id = rtu.valid_restriction_id
760: and rtu.restriction_usage_id = p_rec.fk_value1;