[Home] [Help]
304: -- get valid user waiver
305: l_valid_user_waiver_count NUMBER;
306: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER, l_user_id IN NUMBER) IS
307: SELECT count(*)
308: FROM amw_constraint_waivers_vl
309: WHERE constraint_rev_id = l_constraint_rev_id
310: AND object_type = 'USER'
311: AND PK1 = l_user_id
312: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
1981: ||' WHERE resp.request_group_id = rgu.request_group_id '
1982: ||' AND rgu.request_unit_type = ''P'' '
1983: ||' AND rgu.request_unit_id = ce.function_id AND ce.object_type = ''CP'' '
1984: ||' AND ce.CONSTRAINT_REV_ID = :3 '
1985: ||' AND resp.responsibility_id NOT IN (select cw.pk1 from amw_constraint_waivers_vl cw '
1986: ||' where cw.constraint_rev_id=ce.CONSTRAINT_REV_ID '
1987: ||' and cw.object_type=''RESP'' '
1988: ||' and cw.start_date<=sysdate '
1989: ||' and (cw.end_date >= sysdate or cw.end_date is null)) '
2009: ||' WHERE resp.menu_id = cmf.menu_id '
2010: ||' AND cmf.function_id = ce.function_id and cmf.grant_flag = ''Y'' '
2011: ||' AND (ce.OBJECT_TYPE is null OR ce.OBJECT_TYPE = ''FUNC'') '
2012: ||' AND ce.CONSTRAINT_REV_ID = :1 '
2013: ||' AND resp.responsibility_id NOT IN (select cw.pk1 from amw_constraint_waivers_vl cw '
2014: ||' where cw.constraint_rev_id=ce.CONSTRAINT_REV_ID '
2015: ||' and cw.object_type=''RESP'' '
2016: ||' and cw.start_date<=sysdate '
2017: ||' and (cw.end_date >= sysdate or cw.end_date is null)) '