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

Line 671: FROM cn_groups_denorm_v

667: AND salesrep_id = p_parent_salesrep_id
668: AND org_id = g_org_id
669: AND EXISTS(
670: SELECT 1
671: FROM cn_groups_denorm_v
672: WHERE parent_group_id = a1.comp_group_id
673: AND GROUP_ID IN(
674: SELECT comp_group_id
675: FROM cn_srp_comp_groups_v

Line 683: FROM cn_groups_denorm_v

679: AND p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date ) );
680:
681: CURSOR rollup_level( p_parent_group_id NUMBER, p_child_group_id NUMBER, p_rollup_date DATE ) IS
682: SELECT denorm_level
683: FROM cn_groups_denorm_v
684: WHERE parent_group_id = p_parent_group_id
685: AND GROUP_ID = p_child_group_id
686: AND p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date );
687: