APPS.AMV_USER_PVT dependencies on DUAL

Line 28: G_RESOURCE_ROLE_CODE CONSTANT VARCHAR2(30) := 'RS_INDIVIDUAL';

24: --
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMV_USER_PVT';
26: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amvvusrb.pls';
27: --
28: G_RESOURCE_ROLE_CODE CONSTANT VARCHAR2(30) := 'RS_INDIVIDUAL';
29: G_GROUP_ROLE_CODE CONSTANT VARCHAR2(30) := 'RS_GROUP';
30: -- Debug mode
31: G_DEBUG boolean := FALSE;
32: --G_DEBUG boolean := TRUE;

Line 242: From Dual;

238: l_access_obj AMV_ACCESS_OBJ_TYPE;
239: --
240: CURSOR Get_IDandDate_csr is
241: Select amv_u_access_s.nextval, sysdate
242: From Dual;
243: --
244: BEGIN
245: SAVEPOINT Add_Access_helper_PVT;
246: -- Get the current (login) user id.

Line 2021: From dual

2017: --
2018: CURSOR Get_GroupRole_csr(p_res_id IN NUMBER) IS
2019: Select
2020: 1
2021: From dual
2022: Where exists
2023: (
2024: select r.role_id
2025: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,

Line 2039: From dual

2035: --
2036: CURSOR Get_GroupRole2_csr(p_res_id IN NUMBER) IS
2037: Select
2038: 1
2039: From dual
2040: Where exists
2041: (
2042: select r.role_id
2043: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,