APPS.CN_SFP_SRP_UTIL_PVT dependencies on CN_QM_COMP_GROUPS

Line 402: FROM cn_qm_comp_groups g, cn_user_accesses u

398:
399:
400: CURSOR Get_Access(c_user_id NUMBER ,c_date DATE ,p_org_code VARCHAR) IS
401: SELECT u.comp_group_id group_id , u.access_code access_code
402: FROM cn_qm_comp_groups g, cn_user_accesses u
403: WHERE u.user_id = c_user_id
404: AND g.comp_group_id = u.comp_group_id
405: AND c_date BETWEEN Trunc(g.start_date_active) AND
406: Nvl(Trunc(g.end_date_active), c_date )