APPS.AMS_CATEGORY_PVT dependencies on DUAL

Line 92: FROM dual;

88: l_count NUMBER;
89:
90: CURSOR C_category_seq IS
91: SELECT ams_categories_b_s.NEXTVAL
92: FROM dual;
93:
94: CURSOR C_category_count(my_category_id VARCHAR2) IS
95: SELECT COUNT(*)
96: FROM AMS_CATEGORIES_B

Line 1559: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,

1555: l_return_status VARCHAR2(1); -- Return value from procedures
1556: l_item_name VARCHAR2(30); -- Return value from procedures
1557: l_dummy NUMBER;
1558: cursor c_ctg_name_crt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1559: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1560: AMS_CATEGORIES_B b
1561: where t.category_name = ctg_name_in
1562: and b.arc_category_created_for = ctg_arc_in
1563: and language = userenv('LANG')

Line 1569: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,

1565: --and t.category_id = ctg_id_in
1566: --and b.category_id = ctg_id_in
1567: );
1568: cursor c_ctg_name_updt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1569: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1570: AMS_CATEGORIES_B b
1571: where t.category_name = ctg_name_in
1572: and b.arc_category_created_for = ctg_arc_in
1573: and language = userenv('LANG')