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_VALID_RESTRICTION

Line 551: hr_summary_valid_restriction vr

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
555: and ru.business_group_id = p_bus_grp_id;

Line 653: hr_summary_valid_restriction vr

649: cursor csr_get_sql is
650: select rt.restriction_sql
651: , rt.business_group_id
652: from hr_summary_restriction_type rt,
653: hr_summary_valid_restriction vr
654: where rt.restriction_type_id = vr.restriction_type_id
655: and rt.business_group_id = vr.business_group_id
656: and vr.valid_restriction_id = p_valid_restriction_id;
657: --

Line 755: hr_summary_valid_restriction vr,

751: --
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