APPS.EDR_POLICY_FUNCTION_PKG dependencies on EDR_SECURE_ELEMENTS_V

Line 60: from edr_security_rules a, edr_secure_elements_v b

56:
57: --for low (default) security level- everyone is granted access by default
58: cursor c1 is
59: select a.event_name, b.index_section_name, upper(a.secure_value) secure_value
60: from edr_security_rules a, edr_secure_elements_v b
61: where ((a.user_id = l_user or a.responsibility_id = l_resp) and a.access_code = 'R')
62: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
63: and a.ELEMENT_ID = b.ELEMENT_ID
64: minus

Line 66: from edr_security_rules a, edr_secure_elements_v b

62: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
63: and a.ELEMENT_ID = b.ELEMENT_ID
64: minus
65: select a.event_name, b.index_section_name, upper(a.secure_value) secure_value
66: from edr_security_rules a, edr_secure_elements_v b
67: where (a.user_id = l_user and a.access_code = 'G')
68: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
69: and a.ELEMENT_ID = b.ELEMENT_ID
70: order by event_name desc, index_section_name;

Line 75: from edr_security_rules a, edr_secure_elements_v b

71:
72: --for high securiy level- everyone has to be granted access
73: cursor c2 is
74: select a.event_name, b.index_section_name, upper(a.secure_value) secure_value
75: from edr_security_rules a, edr_secure_elements_v b
76: where ((a.user_id = l_user or a.responsibility_id = l_resp) and a.access_code = 'G')
77: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
78: and a.ELEMENT_ID = b.ELEMENT_ID
79: minus

Line 81: from edr_security_rules a, edr_secure_elements_v b

77: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
78: and a.ELEMENT_ID = b.ELEMENT_ID
79: minus
80: select a.event_name, b.index_section_name, upper(a.secure_value) secure_value
81: from edr_security_rules a, edr_secure_elements_v b
82: where (a.user_id = l_user and a.access_code = 'R')
83: and (a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null))
84: and a.ELEMENT_ID = b.ELEMENT_ID
85: order by event_name desc, index_section_name;