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.CN_SALES_HIER_PUB dependencies on CN_SALESREPS

Line 96: cn_salesreps cs

92: cscg.end_date_active mgr_end_date
93:
94: FROM
95: cn_srp_comp_groups_v cscg,
96: cn_salesreps cs
97: WHERE
98: cscg.comp_group_id = l_comp_group_id AND -- (master-detail passed in value)
99: ((cscg.end_date_active is null) OR
100: (cscg.end_date_active >= l_date)) AND

Line 121: cn_salesreps cs

117: cscg.start_date_active srp_start_date,
118: cscg.end_date_active srp_end_date
119: FROM
120: cn_srp_comp_groups_v cscg,
121: cn_salesreps cs
122: WHERE
123: cscg.comp_group_id = l_comp_group_id AND -- (master-detail passed value)
124: cscg.salesrep_id = cs.salesrep_id AND
125: cscg.start_date_active <= l_date AND