DBA Data[Home] [Help]

APPS.AMS_APPROVAL_DETAILS_PVT dependencies on AMS_CATEGORIES_B

Line 1724: WHERE EXISTS (SELECT 1 FROM ams_categories_b

1720: AND sysdate between hou.date_from and nvl(hou.date_to,sysdate +1 );
1721:
1722: Cursor c_appr_objt_type_exists(id_in IN NUMBER) IS
1723: SELECT 1 FROM dual
1724: WHERE EXISTS (SELECT 1 FROM ams_categories_b
1725: WHERE enabled_flag = 'Y'
1726: AND arc_category_created_for = 'FUND'
1727: AND category_id = id_in);
1728: