APPS.PA_PLANNING_RESOURCE_PVT dependencies on DUAL

Line 592: FROM dual;

588: decode(l_supplier_name, NULL, NULL, '-' || l_supplier_name) ||
589: decode(l_role_name, NULL, NULL, '-' || l_role_name) ||
590: decode(l_inc_by_name, NULL, NULL, '-' || l_inc_by_name)
591: INTO g_token
592: FROM dual;
593: IF l_res_type IS NULL THEN
594: g_token := replace(g_token, ' -', ' ');
595: END IF;
596: g_token := g_token || ':';

Line 850: FROM dual;

846: ************************************************/
847: IF l_res_list_member_id IS NULL THEN
848: SELECT pa_resource_list_members_s.NEXTVAL
849: INTO l_res_list_member_id
850: FROM dual;
851: END IF;
852:
853: If l_inventory_item_id is Not Null Then
854:

Line 1383: FROM DUAL

1379: * it. We will only set the enabled_flag = 'Y'.
1380: **********************************************************/
1381: SELECT 'Y'
1382: INTO l_exist_res_list
1383: FROM DUAL
1384: WHERE EXISTS
1385: (SELECT 'Y' from pa_resource_assignments
1386: WHERE resource_list_member_id = p_resource_list_member_id
1387: UNION

Line 1760: FROM dual;

1756: l_bulk_resource_list_member_id.last
1757: LOOP
1758: SELECT pa_resource_list_members_s.NEXTVAL
1759: INTO l_new_resource_list_member_id(i)
1760: FROM dual;
1761: END LOOP;
1762:
1763: END IF;
1764: