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_COMP_GROUPS_V

Line 108: FROM cn_srp_comp_groups_v cscg,

104: intel.period_id,
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

Line 122: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v scg

118: select distinct ct.name name,
119: ct.comp_team_id team_id,
120: greatest(scg.start_date_active, ct.start_date_active) start_date,
121: Least(nvl(ct.end_date_active, l_max_date) , nvl(scg.end_date_active, l_max_date)) end_date
122: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v scg
123: where scg.role_id = p_role_id
124: and srt.salesrep_id = scg.salesrep_id
125: and srt.comp_team_id = ct.comp_team_id
126: and (scg.start_date_active <= ct.start_date_active