APPS.AMS_ACTCATEGORY_PVT dependencies on DUAL

Line 58: FROM dual;

54: l_act_category_id NUMBER;
55:
56: CURSOR C_act_category_id IS
57: SELECT ams_act_categories_s.NEXTVAL
58: FROM dual;
59:
60: BEGIN
61:
62: -- Standard Start of API savepoint

Line 760: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES

756:
757: CURSOR c_act_ctg_id_exists(ctg_id_in IN NUMBER,
758: arc_used_by in VARCHAR2,
759: arc_used_id_in in NUMBER) IS
760: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES
761: WHERE category_id = ctg_id_in
762: and ARC_ACT_CATEGORY_USED_BY = arc_used_by
763: and ACT_CATEGORY_USED_BY_ID = arc_used_id_in);
764:

Line 923: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES

919: CURSOR c_act_ctg_id_exists(ctg_id_in IN NUMBER,
920: obj_ver_in IN NUMBER,
921: arc_used_by in VARCHAR2,
922: arc_used_id_in in NUMBER) IS
923: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES
924: WHERE category_id = ctg_id_in
925: and object_version_number = obj_ver_in
926: and ARC_ACT_CATEGORY_USED_BY = arc_used_by
927: and ACT_CATEGORY_USED_BY_ID = arc_used_id_in);