DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on DUAL

Line 18: from dual

14: IS
15:
16: CURSOR chk_if_exists IS
17: select 'Y'
18: from dual
19: where ((exists (select 'Y'
20: from pa_resource_list_members
21: where spread_curve_id = p_spread_curve_id))
22: OR (exists (select 'Y'

Line 7486: FROM dual

7482: (l_res_details.inventory_item_id IS NOT NULL) THEN
7483:
7484: SELECT 'Y'
7485: INTO l_rate_based_flag
7486: FROM dual
7487: WHERE NOT EXISTS (select 'Y'
7488: from mtl_system_items_b item,
7489: mtl_units_of_measure meas
7490: where item.inventory_item_id =