APPS.MRP_CL_FUNCTION dependencies on DUAL

Line 1430: FROM dual;

1426: and org.organization_id = p_org_id;
1427:
1428: CURSOR COST_C2 IS
1429: SELECT NVL(FND_PROFILE.VALUE('MSC_COST_TYPE'),1)
1430: FROM dual;
1431:
1432: l_cost_type_id NUMBER:= NULL;
1433:
1434: BEGIN

Line 1509: FROM DUAL;

1505: SELECT SYSDATE,
1506: FND_GLOBAL.USER_ID
1507: INTO v_current_date,
1508: v_current_user
1509: FROM DUAL;
1510:
1511: OPEN regions_update;
1512: FETCH regions_update into region_last_update;
1513: CLOSE regions_update;

Line 1661: FROM DUAL;

1657: SELECT SYSDATE,
1658: FND_GLOBAL.USER_ID
1659: INTO v_current_date,
1660: v_current_user
1661: FROM DUAL;
1662:
1663: lv_mrp_schema := MSC_UTIL.G_MRP_SCHEMA;
1664:
1665: lv_trunc_stmt := ' TRUNCATE TABLE ' || lv_mrp_schema ||