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_ROLLUP_PVT dependencies on CN_GROUPS_DENORM_V

Line 518: FROM cn_groups_denorm_v

514: parent_group_id,
515: denorm_level,
516: greatest(start_date_active, p_group.start_date) start_date,
517: least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
518: FROM cn_groups_denorm_v
519: WHERE group_id = p_group.group_id
520: AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
521: AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);
522: BEGIN

Line 631: FROM cn_groups_denorm_v

627: group_id,
628: denorm_level,
629: greatest(start_date_active, p_group.start_date) start_date,
630: least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
631: FROM cn_groups_denorm_v
632: WHERE parent_group_id = p_group.group_id
633: AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
634: AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);
635: BEGIN

Line 1135: cn_groups_denorm_v hier

1131:
1132: CURSOR descendant_csr(p_group_id NUMBER) IS
1133: SELECT DISTINCT salesrep_id
1134: FROM cn_srp_comp_groups_v srp,
1135: cn_groups_denorm_v hier
1136: WHERE srp.comp_group_id = hier.group_id
1137: AND srp.org_id = p_org_id
1138: AND hier.parent_group_id = p_group_id
1139: AND (p_srp.end_date IS NULL OR hier.start_date_active <= p_srp.end_date)