APPS.CN_SFP_SRP_UTIL_PVT dependencies on CN_USER_ACCESSES

Line 386: l_org_code CN_USER_ACCESSES.ORG_CODE%TYPE := NULL ;

382: l_match_rows NUMBER := 0 ;
383: l_sql VARCHAR2(4000) := '' ;
384:
385: l_date DATE := SYSDATE ;
386: l_org_code CN_USER_ACCESSES.ORG_CODE%TYPE := NULL ;
387: l_user_id NUMBER ;
388: l_include_string VARCHAR2(2000) := ' ' ;
389: l_exclude_string VARCHAR2(2000) := ' ' ;
390: l_exclude_string_2 VARCHAR2(2000) := ' ' ;

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 )