DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on DUAL

Line 389: FROM DUAL

385: AND lh.last_update_date > l_latest_comp_date;
386:
387: CURSOR c_product_exists(l_item_id NUMBER, l_schedule_id NUMBER) IS
388: SELECT 'Y'
389: FROM DUAL
390: WHERE EXISTS (
391: SELECT 1
392: FROM ams_act_products
393: WHERE inventory_item_id = l_item_id

Line 401: FROM DUAL

397: );
398:
399: CURSOR c_category_exists(l_category_id NUMBER, l_schedule_id NUMBER) IS
400: SELECT 'Y'
401: FROM DUAL
402: WHERE EXISTS (
403: SELECT 1
404: FROM ams_act_products
405: WHERE category_id = l_category_id