DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on DUAL

Line 14: from dual

10: IS
11:
12: CURSOR chk_if_exists IS
13: select 'Y'
14: from dual
15: where ((exists (select 'Y'
16: from pa_resource_list_members
17: where spread_curve_id = p_spread_curve_id))
18: OR (exists (select 'Y'

Line 7328: FROM dual

7324: (l_res_details.inventory_item_id IS NOT NULL) THEN
7325:
7326: SELECT 'Y'
7327: INTO l_rate_based_flag
7328: FROM dual
7329: WHERE NOT EXISTS (select 'Y'
7330: from mtl_system_items_b item,
7331: mtl_units_of_measure meas
7332: where item.inventory_item_id =