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_TYPE

Line 549: from hr_summary_restriction_type rt,

545: cursor csr_lov_exists (p_ru_id number,
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

Line 652: from hr_summary_restriction_type rt,

648: --
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;

Line 754: from hr_summary_restriction_type rt,

750: Function chk_date_valid (p_rec in per_bil_shd.g_rec_type) return boolean is
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