APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on CN_COMP_GROUPS

Line 75: FROM cn_comp_groups

71:
72: -- cursor to get the name of the group identified by p_group_id
73: CURSOR group_name IS
74: SELECT name
75: FROM cn_comp_groups
76: WHERE comp_group_id = g_group_id;
77:
78: -- cursor to find all periods in the date range for each srp
79: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS

Line 370: FROM cn_comp_groups

366:
367: -- cursor to get the name of the group identified by p_group_id
368: CURSOR group_name IS
369: SELECT name
370: FROM cn_comp_groups
371: WHERE comp_group_id = l_group_id;
372:
373: -- cursor to find all periods in the date range for each srp
374: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS

Line 594: FROM cn_comp_groups

590:
591: -- cursor to get the name of the group identified by p_group_id
592: CURSOR group_name IS
593: SELECT name
594: FROM cn_comp_groups
595: WHERE comp_group_id = p_group_id;
596:
597: -- cursor to find all periods in the date range for each srp
598: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS