APPS.AMS_ACCESS_PVT dependencies on DUAL

Line 59: FROM DUAL;

55: --End:Fix for Bug#10192372
56:
57: CURSOR c_access_seq IS
58: SELECT ams_act_access_s.NEXTVAL
59: FROM DUAL;
60:
61: CURSOR c_access_count(l_access_id IN NUMBER) IS
62: SELECT COUNT(*)
63: FROM ams_act_access

Line 97: FROM DUAL

93: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
94:
95: CURSOR c_group_exists IS
96: SELECT 1
97: FROM DUAL
98: WHERE NOT EXISTS(SELECT 1
99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object

Line 334: FROM DUAL

330: decode(l_access_rec.owner_flag,'Y','Y',nvl(l_access_rec.admin_flag,'N') ),
331: l_access_rec.approver_flag,
332: l_access_rec.owner_flag,
333: 'N'
334: FROM DUAL
335: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_schedule_rec.schedule_id
336: and arc_act_access_to_object = 'CSCH'
337: and user_or_role_id = l_access_rec.user_or_role_id
338: and arc_user_or_role_type = 'USER');

Line 437: FROM DUAL

433: decode(l_access_rec.owner_flag,'Y','Y',nvl(l_access_rec.admin_flag,'N') ),
434: l_access_rec.approver_flag,
435: l_access_rec.owner_flag,
436: 'N'
437: FROM DUAL
438: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_qp_list_header_id
439: and arc_act_access_to_object = 'OFFR'
440: and user_or_role_id = l_access_rec.user_or_role_id
441: and arc_user_or_role_type = 'USER');

Line 2221: -- FROM DUAL

2217: -- Following code is commented by ptendulk on 18Jul2000
2218: --=============================================================================
2219: -- CURSOR c_group_access IS
2220: -- SELECT 1
2221: -- FROM DUAL
2222: -- WHERE EXISTS(
2223: -- SELECT 1
2224: -- FROM ams_act_access A, jtf_rs_group_members_vl B
2225: -- WHERE A.arc_act_access_to_object = p_object_type

Line 2236: FROM DUAL

2232: -- AND B.resource_id = p_user_or_role_id);
2233:
2234: CURSOR c_group_access(c_grp_id NUMBER) IS
2235: SELECT 1
2236: FROM DUAL
2237: WHERE EXISTS(
2238: SELECT 1
2239: FROM ams_act_access
2240: WHERE arc_act_access_to_object = p_object_type

Line 2753: FROM DUAL

2749: -- cursor added by julou 29-nov-2001 ref. bug 2117645
2750: /*
2751: CURSOR c_user_exist IS
2752: SELECT 1
2753: FROM DUAL
2754: WHERE EXISTS(SELECT 1
2755: FROM ams_act_access
2756: WHERE act_access_to_object_id = p_access_rec.act_access_to_object_id
2757: AND arc_act_access_to_object = p_access_rec.arc_act_access_to_object