APPS.PA_PLANNING_RESOURCE_PVT dependencies on DUAL

Line 642: FROM dual;

638: decode(l_supplier_name, NULL, NULL, '-' || l_supplier_name) ||
639: decode(l_role_name, NULL, NULL, '-' || l_role_name) ||
640: decode(l_inc_by_name, NULL, NULL, '-' || l_inc_by_name)
641: INTO g_token
642: FROM dual;
643: IF P_PA_DEBUG_MODE = 'Y' THEN
644: pa_debug.write('Create_Planning_Resource: ' || g_module_name,'g_token4 '|| g_token ,1);
645: END IF;
646: IF l_res_type IS NULL THEN

Line 941: FROM dual;

937: ************************************************/
938: IF l_res_list_member_id IS NULL THEN
939: SELECT pa_resource_list_members_s.NEXTVAL
940: INTO l_res_list_member_id
941: FROM dual;
942: END IF;
943:
944: If l_inventory_item_id is Not Null Then
945:

Line 1491: FROM DUAL

1487: * it. We will only set the enabled_flag = 'Y'.
1488: **********************************************************/
1489: SELECT 'Y'
1490: INTO l_exist_res_list
1491: FROM DUAL
1492: WHERE EXISTS
1493: (SELECT 'Y' from pa_resource_assignments
1494: WHERE resource_list_member_id = p_resource_list_member_id
1495: UNION

Line 1868: FROM dual;

1864: l_bulk_resource_list_member_id.last
1865: LOOP
1866: SELECT pa_resource_list_members_s.NEXTVAL
1867: INTO l_new_resource_list_member_id(i)
1868: FROM dual;
1869: END LOOP;
1870:
1871: END IF;
1872: