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.JTF_RS_ROLES_VUHK dependencies on CN_SRP_INTEL_PERIODS

Line 109: cn_srp_intel_periods intel

105: greatest(cscg.start_date_active, intel.start_date) start_date,
106: decode(cscg.end_date_active, null, intel.end_date,
107: Least(cscg.end_date_active, intel.end_date)) end_date
108: FROM cn_srp_comp_groups_v cscg,
109: cn_srp_intel_periods intel
110: WHERE cscg.role_id = p_role_id
111: and intel.salesrep_id = cscg.salesrep_id
112: and cscg.start_date_active <= intel.end_date
113: and (cscg.end_date_active is null or